View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Electro7
 
Posts: n/a
Default Formulas dealing with searching for characters

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.