"SUBSTITUTE" Function With Wilcard For Symbols?

[Dhira]

In trying to create a formula that remove EVERY symbol from a cell (C6) and replacing it with a space.... the "SUBSTITUTE" function is telling me I have too many nested Substitutes.

This is the formula:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([COLOR=Red]C6[/COLOR],"/"," "),"%"," "),"!"," "),","," "),"*"," "),"-"," "),"("," "),")"," ")

It works thus far, but I would still like to add more symbols into the nest.
Is there a way/formula to do this that replaces ANY symbol with a space?

 

[Biz]

p45cal & Biz,

Thank you. That did work, however I had to remove the function because I kept on getting a Privacy warning every time I tried to save - incredibly annoying It wouldn't go away even when I changed settings in the trust center (Excel 2007) SO I had to try Joseph's :And it works a treat.
(Had to download morefunc at DOwnload.com since it wasn't available)

Thanks again.

Please note if you forward spreadsheets and it relies on morefunc then it won't work.

Biz

 

[Dhira]

Well morefunc WAS working for a bit, but now when I save the file.... It has #NAME? in the cells instead of results...

Is there any way to use the functions while disabling the privacy notifications?
I tried EVERYTHING in the trust center and it still notifies on every save....

 

[Dhira]

K I figured it out:

<table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="contentRight" style="padding-left: 10px; " valign="top"><table class="tborder" id="post2124734" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(235, 235, 235); color: rgb(0, 0, 0); border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: rgb(235, 235, 235); border-right-color: rgb(235, 235, 235); border-bottom-color: rgb(235, 235, 235); border-left-color: rgb(235, 235, 235); background-position: initial initial; background-repeat: initial initial; " align="center" border="0" cellpadding="6" cellspacing="0" width="100%"><tbody><tr><td class="alt1" id="td_post_2124734" style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(252, 252, 252); color: rgb(122, 122, 122); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(235, 235, 235); background-position: initial initial; background-repeat: initial initial; ">"notifications" -- this message goes away when you un-check the check box labelled "Remove personal information from file properties on save".
</td></tr></tbody></table>

</td></tr></tbody></table>In "Privacy settings" after checking 'enable'.