Thread
:
Column Merging
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Ragdyer
Posts: n/a
Column Merging
With data in Column A and Column B, try this in C:
=A1&B1
Or, to have a space between:
=A1&" "&B1
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Scott McKinney" <Scott
wrote in message
...
Hi. I have two seperate columns with text. I would like to have both
columns
merged together and the text to run on to each other, like one column. I
tried merging the cells but it keeps the upper left data only and deleted
the
other text. Any way to merge these cells? I am importing them from a txt
file
with these columns seperated by commas, delimited file.
Reply With Quote