software

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 www.officekb.com

Hi

Is there anything 'static' in all of the values? Do they all end in MM? Do
they all have two letters after the number? Are they always 4 characters
long?

Andy.

quot;Fam via OfficeKB.comquot; lt;u18245@uwegt; wrote in message
news:5dbd9e59247d0@uwe...
gt; Is there any formula to extract just neumeric value out from a cell which
gt; has
gt; both text and a numerial values?
gt; for example 10MM, and I just like to extract out 10 in different cell.
gt; I have tried left function, but it is specific due to range. So if I put
gt; =left(a2, 2), it will spit out 10 but what if the value is 2, or 750.
gt; Any help will be appreciated.
gt;
gt; --
gt; Message posted via www.officekb.com
ASAP Utilities, an Excel Add-in available free from www.asap-utilities.com
has a feature that will quot;delete all text-characters in the selectionquot;. Just
copy your data to a helper column and apply the feature.

hth
Vaya con Dios,
Chuck, CABGx3
quot;Fam via OfficeKB.comquot; wrote:

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

Thanks for the reponse. No not all of them are four character long. They
varies from 4 to 7. But they all have MM.

wrote:
gt;Hi
gt;
gt;Is there anything 'static' in all of the values? Do they all end in MM? Do
gt;they all have two letters after the number? Are they always 4 characters
gt;long?
gt;
gt;Andy.
gt;
gt;gt; Is there any formula to extract just neumeric value out from a cell which
gt;gt; has
gt;[quoted text clipped - 3 lines]
gt;gt; =left(a2, 2), it will spit out 10 but what if the value is 2, or 750.
gt;gt; Any help will be appreciated.

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...excel/200603/1

So you could use something like this:
=VALUE(LEFT(A2,LEN(A2)-2))

Andy.

quot;Fam via OfficeKB.comquot; lt;u18245@uwegt; wrote in message
news:5dbdd12c79047@uwe...
gt; Thanks for the reponse. No not all of them are four character long. They
gt; varies from 4 to 7. But they all have MM.
gt;
gt; wrote:
gt;gt;Hi
gt;gt;
gt;gt;Is there anything 'static' in all of the values? Do they all end in MM? Do
gt;gt;they all have two letters after the number? Are they always 4 characters
gt;gt;long?
gt;gt;
gt;gt;Andy.
gt;gt;
gt;gt;gt; Is there any formula to extract just neumeric value out from a cell
gt;gt;gt; which
gt;gt;gt; has
gt;gt;[quoted text clipped - 3 lines]
gt;gt;gt; =left(a2, 2), it will spit out 10 but what if the value is 2, or 750.
gt;gt;gt; Any help will be appreciated.
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...excel/200603/1
worked like a charm...thx

wrote:
gt;So you could use something like this:
gt;=VALUE(LEFT(A2,LEN(A2)-2))
gt;
gt;Andy.
gt;
gt;gt; Thanks for the reponse. No not all of them are four character long. They
gt;gt; varies from 4 to 7. But they all have MM.
gt;[quoted text clipped - 14 lines]
gt;gt;gt;gt; =left(a2, 2), it will spit out 10 but what if the value is 2, or 750.
gt;gt;gt;gt; Any help will be appreciated.

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...excel/200603/1