Hello everyone,
I need to split the text from a cell that contains numbers after every appereancesugge of a number.
In cell A1 i have this text : "1515 Provizioane pentru pensii şi obligaţii similare 1516 Provizioane pentru impozite"
I need to split it in 2 cells : first cell value "1515 Provizioane pentru pensii şi obligaţii similare", second cell value "1516 Provizioane pentru impozite"
This is a chart of accounts data, that means for every number a have a corresponding text.
It can be multiple instances of this pattern in a cell, not only 2.
I wrote a formula that extracts the text based on the final number, but that doesnt help me.
I also wrote a formula to extract only the numbers from a cell, and one that extract their position in the cell (1515 would be 1, 1516 would be 8).
I attached an example file with data and my formulas and the desired result.
Any type or help or suggestion is welcomed.
Thank you very much.
Bookmarks