How to find fields that contain a range of characters with high ASCII codes

[joallen]

All,

I've been looking for a creative solution to my problem. My university creates a list of graduates every year to post on multimedia display boards during our graduation. The boards' software chokes on names that have letters with accents... or aren't common in the English language.

Currently, I do a search for each accented or non-English-standard character, and note the row with an X in the second column (the first column contains the names themselves).

I'd like to write a simple function that reads the name, detects if a character exists that's above ASCII Code 127, and marks the second column with some sort of indicator. If possible, I could, instead of using the ASCII Code, just fill in all the different accented characters... in some sort of If/OR/OR/OR command... but I'm afraid I don't know how to write this up.

Can anyone assist?

Thanks much!

Julian

[NBVC]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!