Thread: How do I take out a dash in a number like 827-6541 in a XL list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kelley Kelley is offline
external usenet poster
  
Posts: 20
Default How do I take out a dash in a number like 827-6541 in a XL list
I have a "list of fax #s in xl that I am tyring to send as a broadcast fax.
The service I have requires that the fax number be in a format with no
characters other than the numbers. For example, (912) 678-8344 must be
changed to 19126788344. Not characters other than numbers and no spaces.
Can anyone tell me a way to do this without reinventing the computer?
Reply With QuoteReply With Quote