How to get the number from text?
 

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

How to get the number from text?
 

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

--
Rick (MVP - Excel)


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

How to get the number from text?
 

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









"JJ" wrote:

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

How to get the number from text?
 

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"JJ" wrote:

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