Results 1 to 10 of 11

Thread: Extract Number From Alphanumeric Text

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 02-25-2012, 07:51 AM #1
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    Quote Originally Posted by Excel Fox View Post
    A link that shows hows to extract numbers that are placed together. Ex. ABC123DEF

    Extracting numbers from alphanumeric text
    Here is another formula that does this...

    =LOOKUP(9.9E+307,1*LEFT(MID(A1,MIN(FIND({0,1,2,3,4 ,5,6,7,8,9},A1&"0123456789")),999),ROW($1:$999)))

    I think my formula has more characters in it, but it should still be faster than the code at that link because it has three less function calls and it is not array-entered (just press the ENTER key to commit it).
    Last edited by Rick Rothstein; 05-23-2012 at 07:17 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Extract Numeric Value From Alphanumeric Text Using VBA RegExp
    By Excel Fox in forum Excel Help
    Replies: 2
    Last Post: 03-21-2013, 08:51 PM
  2. Extracting Numeric Values From Alphanumeric Text
    By Safal Shrestha in forum Excel Help
    Replies: 3
    Last Post: 03-21-2013, 12:04 PM
  3. Extract numbers from alphanumeric values
    By tushar.tarafdar in forum Excel Help
    Replies: 3
    Last Post: 09-20-2012, 10:16 PM
  4. Count Alpha In AlphaNumeric Text
    By S M C in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 07-19-2011, 02:32 AM
  5. Remove Zero / Zeroes From Alphanumeric Text
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-04-2011, 01:16 AM

Tags for this Thread

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
  •  

Forum Rules