Dear friends,

Any idea how to desgin a UDF/Formula to replace a character(s) unless some
specific character(s) are preceding?

An example in this regard:

=UDF(A1,"CH","SCH","X") Or
=UDF(A1,B1,C1,D1) with B1:D1 containing the text:
"CH","SCH","X"

in case of an entry in A1, like:

CHECKXCHOWICH

the result comes out to be:

SCHECKXCHOWISCH

because the CH in the mid has an X preceding, it was not replaced but the
two on the sides did change.

Please see if you can help.

Thanx in advance.