Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 (###) ###-####? |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
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,"###-####") |
#4
|
|||
|
|||
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) |
#5
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|