macro find&replace only exact value

[DMR1712]

Hi Everyone,

This macro finds and replaces multiple values found on another sheet. however, it does not only take the exact value, also others.
Example:

If i want to change "Example 1", "Example 2", ... "Example 10" into "One", "two", etc

Example 10 then changes into "One 0" because it changes the Example 1 (without the 0 in 10) into One.

Is there any way to alter this (or do you have another macro to replace multiple values?

Thanks in advance!

Please Login or Register  to view this content.

[protonLeah]

Maybe you could add the: "LookAt:= xlWhole" parameter in the find/replace function or, you might be able to verify that the lengths of the two string are equal.

[DMR1712]

I found a solution (although xlWhole could work too):

if anyone needs this, this is the macro:

Please Login or Register  to view this content.