Merging Columns of Text

[Guest]

I have 3 columns of text (address info) that I need to merge into only one
column. I have over 400 rows that need the same columns merged. Is there any
easy way to do this without entering a formula for each cell?

 

[Nick Hodge]

Buddy

If I understand correctly, we'll say the data is in A1, B1 and C1. In D1
enter

=A1&" "&B1&" "&C1

and drag the 'fill handle' down the 400 rows. (Note: There is a space
between each double quote)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[kkknie]

Enter a formula for one cell, then copy it to the others.

 

[Frank Kabel]

Hi
use
=A1 & " " & B1 & " " & C1
and copy this down for all rows

 

[Alex]

Suppose your columns of data are columns A, B, and C and
your data starts in row 1 down to row 400.

Can you not just use the concatenate function as
follows...in cell D1 (to consolidate text in A1, B1 and
C1)

=A1&" "&B1&" "&C1 (this will leave a gap between each
piece of original text - if you ain't bothered about that
then use =A1&B1&C1)

Then just drag this formula down to row 400. Now delete
rows A, B, and C and you should be left with a single
column containing consolidated addresses...

Are you any nearer to what you want to achieve?

Alex