how do I remove unwanted characters within a text string.

B

bill

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

Fred Smith

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
 
D

Dave Peterson

Is there any chance that the ()'s mean that the results (numbers) should be
negative?

Could it be a formatting change instead?
 
Top