+ Reply to Thread
Results 1 to 3 of 3

Extract number from Alpha numeric Alpha Numeric sequence

  1. #1
    Registered User
    Join Date
    05-29-2019
    Location
    London
    MS-Off Ver
    1905
    Posts
    2

    Extract number from Alpha numeric Alpha Numeric sequence

    Hi there.
    Ive been successful until now googling what I need, but am now stuck with this issue/query
    I have cells containing order number data which is a mix of alpha numeric alpha and numeric.
    See example.

    EM243811
    EM231390P01
    EM23263IT

    I need to extract or end up with the following:
    243811
    231390
    23263

    The best I can get is

    243811
    23139001 - the 01 on the end I dont need and I cant get it to be excluded.
    23263

    Any help appreciated.

    Thanks

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Extract number from Alpha numeric Alpha Numeric sequence

    one option:

    =LOOKUP(9.99E+307,MID(A1,MIN(INDEX(FIND(ROW($1:$10)-1,A1&1234567890),0)),ROW($1:$15))+0)

    if # always starts from char 3

    =LOOKUP(9.99E+307,MID(A1,3,ROW($1:$15))+0)

  3. #3
    Registered User
    Join Date
    05-29-2019
    Location
    London
    MS-Off Ver
    1905
    Posts
    2

    Re: Extract number from Alpha numeric Alpha Numeric sequence

    thankyou so much :-)

+ 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] formula to extract number from alpha numeric data according to specific column criteria
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-28-2017, 07:52 AM
  2. [SOLVED] Return latest Alpha / Numeric / Numeric Alpha Revision
    By cthompson30 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-16-2017, 10:31 AM
  3. Replies: 7
    Last Post: 02-25-2014, 02:00 AM
  4. Help to insert multiple hyphens in an alpha numeric sequence
    By rcleduc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2012, 04:10 PM
  5. Replies: 2
    Last Post: 06-18-2010, 05:10 PM
  6. Extract Number from Alpha Numeric String
    By ausboi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-25-2009, 04:31 AM
  7. only extract numeric value from alpha numeric cell
    By Fam via OfficeKB.com in forum Excel General
    Replies: 5
    Last Post: 04-26-2006, 01:55 PM

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