Taking out numbers in a cell

[Coldzero]

Is it possible to take just the numbers in a cell and calculate them?

For Example if I have 'Price: $50' in cell A1, is there a formula to take just the 50 then divide it by 2 or something like that?

[VBA Noob]

Maybe

=LOOKUP(99^99,--(0&MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&1234567890)),ROW(INDIRECT("1:"&LEN(A1)+1)))))/2

Formula from this link

http://www.excelforum.com/showthread.php?t=630231

Always worth searching the site first

VBA Noob

[Coldzero]

Thanks

I tried searching and I just got a blank page. I'm not sure if it was because it didn't find it or it had an error. I probably did something wrong or didn't search the right thing.

[shg]

Just click the link and give the page enough time to load.

That said, unless you're dealing with legacy data and have absolutely no alternative, mixing words and numbers is terrible practice.

[olasa]

If the text starts with a $ sign and has a 1000 Separator:
"The price is $50,000 for the car."

You could use:

=SUBSTITUTE(LEFT(MID(A1,1+FIND("$",A1),256)&" ",FIND(" ",MID(A1,1+FIND("$",A1),256)&" ")-1),",","")

//Ola