Jamie0886
New member
- Joined
- Jun 8, 2021
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Microsoft Excel 365 & 2016
[FONT="]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.[/FONT]
[FONT=Segoe UI, Helvetica Neue, Helvetica, Roboto, Oxygen, Ubuntu, Cantarell, Fira Sans, Droid Sans, sans-serif]First time poster, so take it easy on me. Thanks in advance guys.[/FONT]
[FONT=Segoe UI, Helvetica Neue, Helvetica, Roboto, Oxygen, Ubuntu, Cantarell, Fira Sans, Droid Sans, sans-serif]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.[/FONT]
[FONT=Segoe UI, Helvetica Neue, Helvetica, Roboto, Oxygen, Ubuntu, Cantarell, Fira Sans, Droid Sans, sans-serif]First time poster, so take it easy on me. Thanks in advance guys.[/FONT]
[FONT=Segoe UI, Helvetica Neue, Helvetica, Roboto, Oxygen, Ubuntu, Cantarell, Fira Sans, Droid Sans, sans-serif]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.[/FONT]