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

Figures and text combined
 

One way ..

Assuming data posted is representative & running in A1 down
Then placed in B2, copied down:
=TEXT(TIME(LEFT(A1,SEARCH(" ",A1)-1)+1,0,0),"hh:mm")&" "&MID(A1,SEARCH("
",A1)+1,99)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sarah P" wrote:
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

Figures and text combined
 

Oops, line:
Then placed in B2, copied down:

should have read as:
Then placed in B1, copied down:
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---