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.