View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bob engler bob engler is offline
external usenet poster
 
Posts: 10
Default delete "-" in cells

I am trying to rid all the pucuations "(,),-" from a column of phone
numbers. I
have used the replace function with evrything OK except "-". It says it
finds
no entries with a "-". I tried just - and then '- but it never finds it.
What should
I use to find them?

Thanks.....