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

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

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

"da" wrote:

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