column text merge

P

publicx2001

hi-
i have 3 columns (A, B, C) of data with 100 rows in each column. i want
to combine my data from A,B, and C into column D. i can place this
formula into column D to do what i need: =A1&" "&B1&C1 . How can i
repeat the same for each row automatically? i dont want to type the
formula over and over and edit it for each row. Please Help.
Thanks
Erik
 
L

Leibtek

Go to the bottom-right corner of the fomula cell, click and drag it down
over the next 100 rows.
 
D

David McRitchie

Hi Erik,
Grab the fill handle on cell D1 with the formula and drag down
The fill handle is the bulge near lower right corner of the cell D1 if you select it.

Instead of dragging down if there is something to the left you can
double click the fill handle. More information (suggest you read entire page)
http://www.mvps.org/dmcritchie/excel/fillhand.htm
 
P

publicx2001

wow that was fast. thank you very much for the replies. i have one last
issue to solve. can i format the columns to put a space in, so A+B+C
will loo like this: hamburger smells good rather than:
hamburgersmellsgood ??

thanks
erik
 
Top