Figures and text combined

S

Sarah P

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
 
M

Max

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)
 
Top