Using multiple SUBSTITUTE formula

[dmcnab]

Hi all...I need some help configuring (adding to) an existing formula that I use....it is the SUBSTITUTE formula...I am attaching a small sample....in it, you will see that everything works fine when I am 'substituting' an asterisk or a caret....when I try to add a 3rd item (the ?...see H20), using the same formula format, ie: =IF(H20=0,"",SUBSTITUTE(SUBSTITUTE(H20,"*",""),"^",""),"?","") it says that I have entered too many functions...if I insert another SUBSTITUTE formula, it will make a single ? into a double ?....or return #VALUE.......any help with constructing this would be appreciated..thanks.

[Rudi]

Try this: =IF(F20=0,"",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F20,"*",""),"^",""),"?",""))

[dmcnab]

Hi Rudi...sorry to be so long getting back to you....thanks for your help...I learn something each time I jump on this site.. :):)