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


--
publicx2001
------------------------------------------------------------------------
publicx2001's Profile: http://www.excelforum.com/member.php...o&userid=32288
View this thread: http://www.excelforum.com/showthread...hreadid=520425

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


--
Leibtek
------------------------------------------------------------------------
Leibtek's Profile: http://www.excelforum.com/member.php...o&userid=32287
View this thread: http://www.excelforum.com/showthread...hreadid=520425

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
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"publicx2001" wrote in message
...

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


--
publicx2001
------------------------------------------------------------------------
publicx2001's Profile: http://www.excelforum.com/member.php...o&userid=32288
View this thread: http://www.excelforum.com/showthread...hreadid=520425

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


--
publicx2001
------------------------------------------------------------------------
publicx2001's Profile: http://www.excelforum.com/member.php...o&userid=32288
View this thread: http://www.excelforum.com/showthread...hreadid=520425

=a2&" "&b2&" "&c2


--
Leibtek
------------------------------------------------------------------------
Leibtek's Profile: http://www.excelforum.com/member.php...o&userid=32287
View this thread: http://www.excelforum.com/showthread...hreadid=520425

thanks for the help. workd like a charm

erik


--
publicx2001
------------------------------------------------------------------------
publicx2001's Profile: http://www.excelforum.com/member.php...o&userid=32288
View this thread: http://www.excelforum.com/showthread...hreadid=520425