View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Erik T. Nomad Erik T. Nomad is offline
external usenet poster
 
Posts: 2
Default Stripping Numbers Down to Bare Minimum

Is there a way I can quickly apply formatting to a column of phone
numbers such that I can get rid of all spaces, dashes, slashes and
parentheses and am left with only digits? I'm currently using a "Find
and Replace" command to do this, but I'd like to find a way to save
even more time. Thanks.

E