Any easy way to identify an illegal character
- Thread starter seansr
- Start date
xlstime
Active Member
Hi Seansr,
Use below formula
=IF(SUM(--ISNUMBER(FIND({"\";"/";"*";"?";":";"<";">";"|"},A1)))>0,"INVALID CHAR","")
Referenced from http://www.mrexcel.com/forum/excel-questions/66289-warning-about-illegal-characters.html
Use below formula
=IF(SUM(--ISNUMBER(FIND({"\";"/";"*";"?";":";"<";">";"|"},A1)))>0,"INVALID CHAR","")
Referenced from http://www.mrexcel.com/forum/excel-questions/66289-warning-about-illegal-characters.html