Figures and text combined

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining text from multiple cells 6
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
If formula and Data Validation parallely 1
Combining Cells 2
Excel Need Countifs Formula Help 0
Excel Typed text appears in wrong cell 0
Comparison of columns using Conditional Formatting 3
Finding specific text in one cell and returning data from another 8

Back
Top