Formatting Phone Numbers in a Merged Cells...

[Steve]

If I want to merge a "Company Name", "Phone Number" and a "Fax" number into
1 cell (for use in a drop down box), is there a way to maintain the 10 digit
format for the phone/fax numbers?

The phone/fax #'s appear as a string of 10 digits when they are merged, and
are hard to read.

Currently using a formula like this: =A3&" Phone: "&B3&" Fax: "&C3

I am tired of trying to get it to work, and can't seem to find the answer
here.

Thank you in advance!

 

[JE McGimpsey]

One way:

=A3 & TEXT(B3,""" Phone: ""000-000-0000") & TEXT(C3,""" Fax:
""000-000-0000")

 

[Steve]

Thank you very much!

One way:

=A3 & TEXT(B3,""" Phone: ""000-000-0000") & TEXT(C3,""" Fax:
""000-000-0000")