A link that shows hows to extract numbers that are placed together. Ex. ABC123DEF
http://www.familycomputerclub.com/ex...eric-text.html
A link that shows hows to extract numbers that are placed together. Ex. ABC123DEF
http://www.familycomputerclub.com/ex...eric-text.html
Last edited by Rick Rothstein; 02-25-2012 at 07:50 AM.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Here is another formula that does this...Originally Posted by Excel Fox
=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.
Posting Permissions
Reply With Quote
Bookmarks