Nov 06 2022 12:13 AM
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 automated process for the 1000+ rows in the worksheet.
example:
Row A1 'This is the text 1. this is the list of tems 2. more text, 3. more text'
Desired result
A1 B1
'This is the text' '1. this is the list of tems 2. more text, 3. more text'
Nov 06 2022 12:51 AM
@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.
Nov 11 2022 02:27 AM