How to get the number from text?

[JJ]

I have data as this format: 025BNN, 033WGN, I want to get only the numbers
from the text. how can i do that? thx.

 

[Rick Rothstein]

Get them how (what format)? Put them where (same cell, different cells)?

 

[xlmate]

if all your data are in this format with the first 3 characters being 'number'

use =LEFT(A2,3)

this assume data start at row 2.

HTH

--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis

 

[Shane Devenshire]

Hi

And assuming you want them as number and that they are always 3 number
followed by any number of things:

=--LEFT(A1,3)

If there can be any number of number before the text then:

=LOOKUP(9^9,--MID(D9,1,ROW(INDIRECT("1:"&LEN(D9)))))

Note that both of these return number not text numbers.