Extracting Just Numbers

[mizunobill]

Is there an easy way to extract only numbers from a cell. Example: The cell contains: FR 235X20-18.2 TRXAT

I want to be able to get 23520182 from that cell

[NBVC]

If you download and install Morefunc.xll from here for free: http://download.cnet.com/Morefunc/30...-10423159.html

then apply formula:

=REGEX.SUBSTITUTE(A1,"[^0-9]","")

[contaminated]

VBA can help u
take a look here
http://www.ozgrid.com/VBA/ExtractNum.htm


edit

delete no way...

[Ron Coderre]

With
A1 containing an alphanumeric string: eg 9128ABC37DEF465

This ARRAY FORMULA, committed with CTRL+SHIFT+ENTER
(instead of just ENTER) returns ONLY the numbers:

Please Login or Register  to view this content.

In the above example, the formula returns: 912837465

Note: That particular formula only works with strings up to 25 chars containing up to 15 digits.

Is that something you can work with?