I have a sheet with about 1500 rows and in each row there will be two or three occurences of text. This text will always start the same but with four numbers at the end which will be different. Example: SSS-DEWBU-1234 and SSS-DEWBU-3456. There will be a lot of other text in each cell, and a typical single cell example is:
This is an example of the text in
each cell. Where the text varies.
Further text to display the this
example of cell contents
I need to lookup each cell in the column and extract the SSS-DEWBU-1234 and the SSS-DEWBU-3456 from each cell in the column and copy it to the adjacent cell. So where there are two of these in one cell, the first will go to column B and the second to column C. I've attached a workbook with three in one cell to see what it should finish up with.