software

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: =A1amp;quot; quot;amp;B1amp;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: www.excelforum.com/member.php...oamp;userid=32288
View this thread: 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: www.excelforum.com/member.php...oamp;userid=32287
View this thread: www.excelforum.com/showthread...hreadid=520425Hi 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)
www.mvps.org/dmcritchie/excel/fillhand.htm
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;publicx2001quot; gt; wrote in message
news
gt;
gt; hi-
gt; i have 3 columns (A, B, C) of data with 100 rows in each column. i want
gt; to combine my data from A,B, and C into column D. i can place this
gt; formula into column D to do what i need: =A1amp;quot; quot;amp;B1amp;C1 . How can i
gt; repeat the same for each row automatically? i dont want to type the
gt; formula over and over and edit it for each row. Please Help.
gt; Thanks
gt; Erik
gt;
gt;
gt; --
gt; publicx2001
gt; ------------------------------------------------------------------------
gt; publicx2001's Profile: www.excelforum.com/member.php...oamp;userid=32288
gt; View this thread: www.excelforum.com/showthread...hreadid=520425
gt;

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: www.excelforum.com/member.php...oamp;userid=32288
View this thread: www.excelforum.com/showthread...hreadid=520425
=a2amp;quot; quot;amp;b2amp;quot; quot;amp;c2--
Leibtek
------------------------------------------------------------------------
Leibtek's Profile: www.excelforum.com/member.php...oamp;userid=32287
View this thread: www.excelforum.com/showthread...hreadid=520425
thanks for the help. workd like a charm

erik--
publicx2001
------------------------------------------------------------------------
publicx2001's Profile: www.excelforum.com/member.php...oamp;userid=32288
View this thread: www.excelforum.com/showthread...hreadid=520425