Thread: Removing Numbers from a Cell that also has text.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Removing Numbers from a Cell that also has text.
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

" wrote:

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

Reply With QuoteReply With Quote