Merging Columns of Text

B

Buddy

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?
 
N

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
[email protected]
 
A

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
 
Top