Macro for finding out all non-keyboard characters and symbols in a sheet

Hi,

I need a macro code to find out all the non-keyboard characters,symbols(e.g-non-english alphabets, Greek symbols, mathematical operators not in keyboard,etc).

If found, a log report should be created showing which cells it is found, and the first cell would be the current active cell.


Thanks in advance !!!

Hello Merry,

Welcome to the Forum!

Did you want the log file to be a separate text file or did you want to create a log sheet in the same workbook you are checking?

Sincerely,
Leith Ross