Format sequence for phone numbers?

L

LACA

I can't figure out what the "text" format of a telephone number is.

If cell A1 contains the text "Telephone"
and cell A2 = (213) 555-1234
(I've formatted cell A2 with Format>Cell>Special>Phone Number so that
it always appears in this format).

I have an output cell with the following formula:

=A1&": "&A2

and I get this:

Telephone: 2135551234

so then I tried to modify my formula to this:

=A1&": "&TEXT(A2,??)

But I don't know what to put where the question marks are.

This should be really simple but I just don't know.

Can someone help?

Thanks.
 
D

Dave Peterson

A2 actually contains: 2135551234, but it's formatted to look nice.

You could try:
=A1&": "&TEXT(A2,"(000) 000-0000")

or if there's a chance that a2 contains a 7 digit number:
=A1&": "&TEXT(A2,"[<=9999999]000-0000;(000) 000-0000")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top