Column Merging

[Scott McKinney]

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.

[Ragdyer]

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 [email protected]> wrote in message
news:[email protected]...
> 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.