Is there any formula to extract just neumeric value out from a cell which has
both text and a numerial values?
for example 10MM, and I just like to extract out 10 in different cell.
I have tried left function, but it is specific due to range. So if I put
=left(a2, 2), it will spit out 10 but what if the value is 2, or 750.
Any help will be appreciated.

--
Message posted via http://www.officekb.com