Why would you even use that at all, just use the ampersand and the unary
minuses to make them real numbers and
then format as phone number? However you would need to copy the formula
17,000 times which is not as hard as it might sound. Just make sure the
column where you use the formula is adjacent to one of the columns with
data, then type the formula in the first cell, press enter. Go back to the
cell you just entered and move the cursor to the lower right corner and when
the cursor changes from a thick cross to a thin, double click the left mouse
button and it will be copied automatically.

Nevertheless using CONCATENATE is not necessary, use the ampersand to do the
same thing.

--


Regards,


Peo Sjoblom

"up4ms" wrote in message
...
Hi Mary
Thanks for the help. I have 17,000. What would the formula look like in
this
situation?

"Mary" wrote:

Hi UP4MS - you need to use the CONCATENATE function.

PHONE - if you have 425-555-1212 in separate columns (425 in cell A1, 555
in
cell B1, and 1212 in cell C1), use =CONCATENATE(A1,"-",B1,"-",C1) in cell
D1
to get 425-555-1212. Eliminate the "-" if you don't want the dashes in
the
results.

Use the same principle to create a name field, where "Joe" in cell A1 and
"Smith" in cell B1 becomes "Joe Smith" by using =CONCATENATE(A1,"-",B1)
in
cell C1.

If you need to rid yourself of the formulas later, just copy and paste
the
results as text.

"up4ms" wrote:

I have imported data to excel. The problem is the phone number is broke
into
three separate colums. Also the customer first name and customer last
name is
broke into two separate colums. I need to mergethe three phone number
colums
into oneand also merge the first and last name into one.

Can someone help me to figure this one out?

Thanks Loren