Mid and isnumber

Joined
Aug 26, 2013
Messages
4
Reaction score
0
Any ideas what is wrong with this formula =1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$10),1)),0),COUNT(1*MID(A1,ROW($1:$10),1)))

This is in column A ~00085965233~

I need to extract only the true number 85965233
 
Joined
Aug 26, 2013
Messages
4
Reaction score
0
Thanks for all your help using the function (Mid, right and left) will work.
However my problem is that my string of numbers in column A: will not always be the same at times it could be 12 digits or 8 or 6. I don't want to have to keep changing the formula line by line that is why I need to use "true"
 
Joined
Dec 28, 2017
Messages
8
Reaction score
1
=MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$10),1)),0),COUNT(1*MID(A1,ROW($1:$10),1)))ctrl,shift,enter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top