• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

conditional formatting to define only speacial character and exclude foreign character

atikah

New Member
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!
 
Back
Top