Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merging 3 cells into 1
Here's an old post about merging 2 columns into one, how can I amend
this formula to make it 3 columns into one maintaining both sets of data? C1: =A1 & " " & B1 now say I want to merge columns A, B, and C? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
merging 3 cells into 1
Joe
If I understand =A1&" "&B1&" "&C1 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk wrote in message oups.com... Here's an old post about merging 2 columns into one, how can I amend this formula to make it 3 columns into one maintaining both sets of data? C1: =A1 & " " & B1 now say I want to merge columns A, B, and C? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
merging 3 cells into 1
Hi,
In cell D1 : =A1&" "&B1&" "&C1 Carim |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
merging 3 cells into 1
Try this; I do it all the time.
D1: =A1 & " " & B1 & " " & C1 " wrote: Here's an old post about merging 2 columns into one, how can I amend this formula to make it 3 columns into one maintaining both sets of data? C1: =A1 & " " & B1 now say I want to merge columns A, B, and C? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
merging 3 cells into 1
Thanks all! There's a little problem though, Column A is the Date
10/20/2006, for some reason it's coming out in the merge as "39010", any way to get the date to show as it is printed? Dave Mc wrote: Try this; I do it all the time. D1: =A1 & " " & B1 & " " & C1 " wrote: Here's an old post about merging 2 columns into one, how can I amend this formula to make it 3 columns into one maintaining both sets of data? C1: =A1 & " " & B1 now say I want to merge columns A, B, and C? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
merging 3 cells into 1
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Merging cells with the same values | Excel Discussion (Misc queries) | |||
Merging Two Cells and Keeping the Values | Excel Discussion (Misc queries) | |||
WRAP a text line over several columns without merging cells | Excel Worksheet Functions | |||
Merging cells with text as one line | Excel Worksheet Functions |