View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default how do I remove unwanted characters within a text string.

You substitute them with nothing, as in:
=Substitute(a1,"(","")

You can nest this command if you want to do more than one character at a
time:
=substitute(substitute(a1,"(",""),")","")

Regards,
Fred

"bill" wrote in message
...
I have parantheses appearing randomally in my results and want to remove
them
from results. Is there a function which would do this.