concatenating and formatting area code and phone number columns

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 (###) ###-####?

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)

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 (###) ###-####?

One easy way is something like:
=TEXT(A1,"(#) ")& TEXT(B1,"###-####")

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)
>
>

Try this

=TEXT(A1,"(000) "&TEXT(B1,"000-0000"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sherri" <[email protected]> wrote in message
news:[email protected]...
> 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)
> >
> >