Merging data from 3 columns

[djqsrv]

Hi
I have found and am using the formula =A1&B1&C1
And that works fine but I can only get it to work on one row at a time. How
would I get this to work on an enire column all at once?
I have phone numbers I need to merge
ColumnA Area Code, ColumnB Prefix and ColumnC 4Dig
In ColumnD I use this formula and it works but I have over a thousand rows I
need to do this on. Is there a way to do this in one step?
Also when I do this if one of the numbers atarts with a 0 it drops it. How
do I get Excel to keep the leading 0's

Thanks for any and all help
Daniel

 

[da]

If you copy the formula from above, all the way to the bottom of your column,
it will merge the data.
Also, when using 0, format it to text instead of a number.
Hope this helps.

 

[djqsrv]

This may sound very noobish but how do you paste the formula al the way down.
When I highlight the column and past it only puts the formula in the first
cell.
Also the 0's are still being dropped with the cells formated as text.
I know this shouldnt be that hard to figure out but I am stumped