Formulas dealing with searching for characters

[Electro7]

Hi,
I have a list of file names including the complete path, and I'm trying
to see if the list has special characters like %, &, @ etc. I am using
the find function now but I have to have a new function to check all
the characters. Is there a way to have just one formula to check to
see a list like

C:\WINDOWS\IE4 Error Log.txt
C:\WINDOWS\KB832854.log

etc has any of the characters I'm searching for?


Thanks for your help.

[daddylonglegs]

If you just want a TRUE/FALSE answer try

=COUNT(FIND({"%","&","@"},A1))>0

[Pete_UK]

The SUBSTITUTE( ) function allows you to change some text to different
text, and so could be used, for example, to change "*" to "". A
composite function could thus be built up of
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( etc ))), but you are limited in this
to the nesting level of 7 so you could not eradicate all the illegal
characters in one formula.

A UDF could do it quite easily.

Hope this helps.

Pete

[Electro7]

daddylonglegs,
Thanks!
you showed me how to include multiple items using find. Got my search
to work correctly now.

Electro7