View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Need to remove text in specific place

Try this (assume A1 is the cell with the data)

=MID(A1,FIND(" ",A1)+1,255)

--


Regards,


Peo Sjoblom

"Scott" <Scott @discussions.microsoft.com wrote in message
...
I need to remove the text in the left most part of the cell up to and
including the point that includes a space.

For example the cell reads: 51253 Axle Housing

I want the 51253 and the space go away.

Thanks