Hi All,
i use the below formula in conditional formatting to highlight the special character.
=IFERROR(MIN(FIND(MID(F75,ROW(INDIRECT("1:"&LEN(F75))),1),G75)),0)=0
exception list: ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz 0123456789.,?()'+/-:
my issue now is i want to exclude foreign character to be include in the speacial character list.
may i know how to i include foreign character in the below exception list?
ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz 0123456789.,?()'+/-:
Thank you in advanced!
i use the below formula in conditional formatting to highlight the special character.
=IFERROR(MIN(FIND(MID(F75,ROW(INDIRECT("1:"&LEN(F75))),1),G75)),0)=0
exception list: ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz 0123456789.,?()'+/-:
my issue now is i want to exclude foreign character to be include in the speacial character list.
may i know how to i include foreign character in the below exception list?
ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz 0123456789.,?()'+/-:
Thank you in advanced!