| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I merge 2 columns of numerical data?
In column A I have the time in hh:mm:ss (13:36:05) format, in column B I have
the millisecond value (0.256). I have 3000 rows of data in this format and I want to combine the columns into one column of format hh:mm:ss.000 (13:36:05.256) how do I do this? I've tried "concatenate" but I think this only works with text (does it?) Can anyone help me? Thanks in advance, this is proving a real head-ache for me. Callum. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| How do I plot two columns of data as one data point/marker in a ch | Charts and Charting in Excel | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
