View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gemi Gemi is offline
external usenet poster
 
Posts: 16
Default Deleting text in a cell

I have a 600 row worksheet were I need to remove the text to the left of the
first space in a cell, all are different lengths. Is there a formula for
that?
For example:
September 8464-005 pin
July 14386 brg
May 5028 washer

In the above I would need to remove the months from each cell. The only
commonality would be the space after the month. End result would be:
8464-005 pin
14386 brg
5028 washer

Any help is greatly appreciated!

Lee