HI, Tech. Where will you get the Area Code that you will 'add in'?
Also, how will you handle single cell entries that _also_ use the
hyphen in a business name (e.g. Allis-Chalmers) or a city (e.g.
Wilkes-Barre, PA) or a 9 digit ZIP code (e.g. 90210-1234)?
Things to ponder....
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=392890