I am having with this marco what is wrong with this formula in excel
~00120457879~ =1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$8), 1)),0),COUNT(1*MID(A1,ROW($1:$8),1)))

I need to extract the number in between the two symbols

First, that doesn't appear to be a macro, just a formula.

Second is that all in one cell? Is all you need to do is extract a number from between the tildes in another cell?

This is the formula I use for that:

=LOOKUP(99^99,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&123456789 0)),ROW(A$1:INDEX(A:A,LEN($A1)))))


This will extract the first numeric string it finds within the long string found in A1. In your string, it effectively pulls out the number.

you'll need to format the cell with this formula to display numbers as 11-digits since once it is converted to a real number, the leading zeros will disappear.

Thanks but I manage to get my macro to work... thanks again

Quote:

---

Originally Posted by Annhelpmehomewk

Thanks but I manage to get my macro to work.... thanks again

---

There is a difference between a macro and a formula. You need to learn what that difference is.

Quote:

---

Originally Posted by ScottGem

There is a difference between a macro and a formula. You need to learn what that difference is.

---

True