Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas dealing with searching for characters
If you just want a TRUE/FALSE answer try =COUNT(FIND({"%","&","@"},A1))0 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=513416 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas dealing with searching for characters
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas dealing with searching for characters
daddylonglegs,
Thanks! you showed me how to include multiple items using find. Got my search to work correctly now. Electro7 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not recognizing new data | Excel Discussion (Misc queries) | |||
Countif formulas change after doing a sort | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Dealing with FALSE and O responses to IF formulas | Excel Worksheet Functions |