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" wrote:

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