Using multiple SUBSTITUTE formula
-
- 3StarLounger
- Posts: 200
- Joined: 24 Aug 2011, 13:13
Using multiple SUBSTITUTE formula
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.
You do not have the required permissions to view the files attached to this post.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Using multiple SUBSTITUTE formula
Try this: =IF(F20=0,"",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F20,"*",""),"^",""),"?",""))
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 200
- Joined: 24 Aug 2011, 13:13
Re: Using multiple SUBSTITUTE formula
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.. :):)