View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jonathan Dunne Jonathan Dunne is offline
external usenet poster
 
Posts: 1
Default How to remove characters from a cell

Hi all

I have a bunch of cells which contain both date and time e.g.

08/16/2005 18:38:32.300
08/16/2005 18:38:32.315
08/16/2005 18:38:34.308

I am wondering what is the correct procedure to remove the first 11
characters from each cell? I can't do a simple find and replace as the date
will change.

Thanks in advance
Jonathan