Hello all!
I have a rather large task to automate:
Column A has cells that have task numbers and titles separated by paragraphs, i.e. cell A1 contains the following:
1. FTTQ 20199 - Title xyz
2. FTPQ 16402 - Title 001
The titles could be anything including having multiple alphanumeric strings, and there may be up to 10 tasks per cell. The prefix is normally FT?Q where ? could be anything and bears no relation to the information I need to extract. All pertinent numeric strings are 5 digits long
I need to break these down to the task numbers only listed in column B such that B1 is 20199, B2 is 16402 using the example above.
I have attached a small sanitised sample spreadsheet that shows roughly the information I have and the information I want to extract.
Cheers! Pete
Bookmarks