Thread: Changing Phone Number Formats
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tha BeatMaker[_5_] Tha BeatMaker[_5_] is offline
external usenet poster
  
Posts: 1
Default Changing Phone Number Formats

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

Reply With QuoteReply With Quote