Forum Discussion
Error if filename contains special characters
I would like to insert a function in a worksheet to check whether the Excel Filename contains special symbols such as "!,.*$%"" and if yes, to output 1 otherwise , to sum a range of numbers.
Any file name contains dot, other symbols in the list are not allowed. That's exactly what you'd like to check?