Thread: Combine Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Union70
 
Posts: n/a
Default Combine Cells


Greetings,

How do I combine A1, A2 and A3 to look like this: 3:15:56? Does it
matter that the data is in Sheet1 and the final product is in Sheet2?
Any help is welcomed.

Sheet 1
Cell Value
A1 03
A2 15
A3 56

Sheet 2
Cell Value
A1 3:15:56

Thanks,
Union


--
Union70