IF STARTS WITH
Solved
holden59
Posted messages
50
Status
Membre
-
holden59 Posted messages 50 Status Membre -
holden59 Posted messages 50 Status Membre -
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.
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 réponses
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!
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!