Thread: Column Merging
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ragdyer
 
Posts: n/a
Default 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.