Thread: Add area code to phone numbers in ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JimDandy[_4_] JimDandy[_4_] is offline
external usenet poster
  
Posts: 1
Default Add area code to phone numbers in ranges

I have a worksheet that has telephone numbers in two seperate columns.
I'd like to locate all the 7-digit numbers (those without area codes)
in both columns and then add a specific area code to all those numbers.
Any number encountered that already has 10 digits I'd like to ignore and
leave alone.


--
JimDandy
------------------------------------------------------------------------
JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578
View this thread: http://www.excelforum.com/showthread...hreadid=514634

Reply With QuoteReply With Quote