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