Extracting numbers out of a cell in Excel

P

pandyav

New member
Joined
Apr 22, 2015
Messages
10
Reaction score
0
Points
0
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!
 

Attachments

  • Example1.xlsx
    8.5 KB · Views: 16
Is the customer Number always the same length?
 
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)
 
You must log in or register to reply here.
Back
Top