If not in Special Phone number format for number including area code
(781-575-5555) use:

=LEFT(J14,3)&MID(J14,5,3)&RIGHT(J14,4)

If no area code then:

+LEFT(J14,3)&RIGHT(J14,4)

J14 represents the cell with the current hyphenated phone number in
it.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=482002