Removing Numbers from a Cell that also has text.

  • Thread starter customerservice
  • Start date
C

customerservice

I have numerous cells that have the following listed in them ... Item#
0012631004
How do I pull only the number out of this cell?
 
B

Bill Kuunders

use edit find replace
find item# with a trailing space if there is one in your cells
replace with leave this blank
 
M

Mike H

Hi I assume yo mean

Item#0012631004

in a cell so try this
=MID(A1,6,LEN(A1))

Yo may have to change the 6 if there are spaces

Mike
 
Top