Results 1 to 3 of 3

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

  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)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,858
    Articles
    0
    Excel Version
    O365
    Does this formula do it?

    Code:
    =MID(A10,FIND("referenceNumber",A10)+17,8)

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,721
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    Administrative Note:

    Welcome to the forum.

    It has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new, I will do it for you this time: https://www.excelforum.com/excel-for...ots-of-it.html.)
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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