Try this
=TEXT(A1,"(000) "&TEXT(B1,"000-0000"))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"sherri" wrote in message
...
Thanks - it worked perfectly.
"." wrote:
Sherri wrote:
I concatenated two columns (area code, phone number) and formatted
them so
area code looks like (###); however, the 7-digit phone number still
appears
as ####### even though I used custom format ###-#### prior to to
concatenating the two columns. Is it possible to add a hyphen so the
final
number looks like (###) ###-####?
Assuming the area code is in A1 and the phone number is in B1, you can
try the following formula in C1: ="("&A1&") "&LEFT(B1,3)&"-"&RIGHT(B1,4)
|