Mid and isnumber function together

Joined
Aug 26, 2013
Messages
4
Reaction score
0
I can not figure out where I went wrong. I need to extract a number from between two symbols ~0039393939~ This is my formula =1*MID(A8,MATCH(TRUE,ISNUMBER(1*MID(A8,ROW($1:$8),1)),0),COUNT(1*MID(A8,ROW($1:$8),1)))
 

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