PDA

View Full Version : Spreadsheets


Annhelpmehomewk
Aug 25, 2013, 03:01 PM
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

ScottGem
Aug 25, 2013, 03:32 PM
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?

JBeaucaire
Aug 26, 2013, 03:50 PM
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&1234567890)),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.

Annhelpmehomewk
Sep 15, 2013, 01:04 PM
Thanks but I manage to get my macro to work... thanks again

ScottGem
Sep 15, 2013, 01:52 PM
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.

Annhelpmehomewk
Sep 15, 2013, 09:36 PM
There is a difference between a macro and a formula. You need to learn what that difference is.

True