joharmenezes
Member
I have a column which has data in the following format
10000200000001XX Abc-Def _old
1000020XX Abc-Def _new
10000200000001XXAbc-Def _old
I want to separate out the text from each of the cells and place them in a different cell. I have tried using "Text to columns" but what happens is, in some cases it breaks up the text as well. I want to know if a formula can give me the desired output?
The number only appears at the start of the cell. Everything after the number has to be placed in another cell. So for the first cell the text will be "XX Abc-Def _old", the 2nd cell "XX Abc-Def _new" and the last cell "XXAbc-Def _old". The number of digits in the start number also vary
10000200000001XX Abc-Def _old
1000020XX Abc-Def _new
10000200000001XXAbc-Def _old
I want to separate out the text from each of the cells and place them in a different cell. I have tried using "Text to columns" but what happens is, in some cases it breaks up the text as well. I want to know if a formula can give me the desired output?
The number only appears at the start of the cell. Everything after the number has to be placed in another cell. So for the first cell the text will be "XX Abc-Def _old", the 2nd cell "XX Abc-Def _new" and the last cell "XXAbc-Def _old". The number of digits in the start number also vary