| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decrease Decimal in a combined text/formula cell | Excel Worksheet Functions | |||
| Decrease Decimal in a combined text/formula cell | Excel Worksheet Functions | |||
| text and number combined in a cell | Excel Worksheet Functions | |||
| Combined & Sorted Text Fields | Excel Discussion (Misc queries) | |||
| text and values combined in one cel | Excel Discussion (Misc queries) | |||
![Sarah P[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
