Results 1 to 3 of 3

Thread: Formula to pull specific information from a cell with unrequired info (lots of it)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte Jamie0886's Avatar
    Join Date
    Jun 2021
    Posts
    1
    Articles
    0
    Excel Version
    Microsoft Excel 365 & 2016

    Formula to pull specific information from a cell with unrequired info (lots of it)

    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.

    First time poster, so take it easy on me. Thanks in advance guys.

    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.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •