View original (French)

IF STARTS WITH

Solved
holden59 Posted messages 50 Status Member -  
holden59 Posted messages 50 Status Member -
Hello,

In Excel 2003, I have in Sheet1 column B, a whole list of sentences starting with the month in number and the year (e.g., 01 2016 blablabla; 02 2016 blabla; 03 2016 bla, etc.)
As this file grows bigger every week and there is no possible order, I would like to have in Sheet2 only what starts with 01 2016; in Sheet3 what starts with 02 2016; and so on.

Does anyone know how to do this, please?

Thank you,

P.S.: I do not want to use the custom filter.

4 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello

    see if this template can be useful for you and come back if you need further explanations

    https://www.cjoint.com/c/FFCh0Dv8hiX

    best regards
    --
    The quality of the answer mainly depends on the clarity of the question, thank you!
    0