Hi all, I have a spreadsheet where the first cell in my row contains the information I need, but also contains over 400 words/characters that I don't need and the information I need is never in the same position. The info I need is a reference number that starts with 19.
Also, I'm no good with VBA's :-( I really hopeful for a formula I can paste into column B and drag it down, as the full version of the report may have up to 50 rows.
Bookmarks