View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah P[_2_] Sarah P[_2_] is offline
external usenet poster
 
Posts: 1
Default Figures and text combined

Hi,
I have time and text in one cell and need to update each cell (there are
1000+) and need to change the time in each cell. I have used the custome
type hh:mm and need to add one hour to each cell. Any ideas? eg:

A1
14.00 Meeting in Manchester