there are methods for detecting special characters and symbols. when I
perform cut and pastes I sometimes find it is necessary to first paste the
data into notepad. then copy again from Notepad to final location.

I use this when copying within Word as well as between many applications
(not only MS). it is a good way of filtering data.

There are lots of special character that can be in the data. Probably too
many to be detected in a worksheet function. This task would be bettter
writing in VBA macro.

"Jeff Ingman" wrote:

I often find symbols in MS documents I'd like to remove or replace with
something else.

Is there a way to detect the underlying code of a symbol or special
character to use for "Search and Replace"?