One person's "non-standard" character could be another person's "that is
just what I need" character. Can you describe what you consider non-standard
characters to be or, if it is easier for you, what a standard character is
to you? Since you are talking about text being pasted in, I guessing the
only way to filter these non-standard characters out (once you identify them
for us) is by using VB code.

--
Rick (MVP - Excel)



"cate" wrote in message
...
User's are pasting text from Word. The results are non standard
character input. These have to be recognized. I can loop thru all
cells. What am I checking for. What is a "hit"?


AND

Is there a format setup that prohibits non standard characters?