How to get the number from text?

  • Thread starter Thread starter JJ
  • Start date Start date
J

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.
 
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
 
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.
 
Back
Top