Forum Discussion
How to split cells to create a new cell starting from a constant character per row
The worksheet has a single column A with each row containing text in which is included "1." I want to cut and paste everything after the "1." ( including the "1.") and put it in column B as an automa...
britso Please see attached file. It contains three possible scenarios, and likely that there are many more.
1. Power Query
2. using TEXTBEFORE and TEXTAFTER (new Insider/Beta functions)
3. using LEFT, RIGHT, FIND and LEN (with dynamic arrays)
4. same as 3 but without dynamic arrays.
See is either of these works for you.
- Yes the TextAfter/before solved it. Thank you very much for the quick response
