View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
msf msf is offline
external usenet poster
 
Posts: 4
Default Changing Phone Number Formats

How do I chane the format of phone numbers in Outlook 2003 contacts? Simple
terms, please

"Tha BeatMaker" wrote:


Consider this example:

A1 - 3365551111
A2 - 336-555-2222
A3 - (336) 555-3333


I want to be able to scan through column A and change all numbers to be
in the format of A1 which is just straight numbers...no punctuation.

How would I do that?


--
Tha BeatMaker
------------------------------------------------------------------------
Tha BeatMaker's Profile: http://www.excelforum.com/member.php...o&userid=23998
View this thread: http://www.excelforum.com/showthread...hreadid=383978