Extracting numbers out of a cell in Excel

[pandyav]

Hello,
I have list of customer numbers (please see the attached sample of data I have). These numbers contain 'numbers' as well 'text'. Is there a way to use some kind of formula that will automatically remove the text from the cells and will give me the 'only' number part of the cell.

Very much appreciate your help in advance,
Thank you!

[NBVC]

Is the customer Number always the same length?

[NBVC]

Assuming it is the same length.. try:

=LEFT(A2,6)

copy down.

otherwise...

=LOOKUP(9.999999999E+307,("0"&MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),ROW($1:$30)))+0)