+ Reply to Thread
Results 1 to 2 of 2

Find a 2nd set of data in a string

  1. #1
    Registered User
    Join Date
    03-29-2014
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    15

    Find a 2nd set of data in a string

    Hello,

    I am hoping to extract 2 somewhat identical pieces of a data from a string of text. We are holding a contest, and the "Coupon" number is the same as the "employee" #. I have formula to extract 1 set of numbers but how do I do the 2nd.

    Here is an example of a string of text: coupon code 11013278 and employee number b017872

    This formula extracts =MID(G5,MIN(FIND({0,1,2,3,4,5,6,7,8,9},G5&1234567890)),8) the first # 10054178 how do I get the 2nd? or this EMPLOYEE NUMBER #10054178 COUPON CODE #10313040

    The string of text is not always in the same order

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Find a 2nd set of data in a string

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.

    Include 1 row for each type of possible entry you have.... string order, presence of # in string, presence of "and" in string etc, etc.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find particular data from complex data string by macro
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-07-2014, 01:24 PM
  2. Find certain string and offset the cell in filtered data
    By orangeballoons in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-25-2013, 12:10 AM
  3. Find string and get column data
    By prav in forum Excel General
    Replies: 10
    Last Post: 10-14-2010, 11:08 PM
  4. Replies: 1
    Last Post: 02-09-2009, 04:56 PM
  5. find string in array with similar data
    By danusko in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-22-2008, 11:19 AM
  6. [SOLVED] find mid value of string data in data with integers
    By Maxi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2006, 12:05 PM
  7. Replies: 8
    Last Post: 03-14-2006, 11:13 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1