Replace word in a sentence

[dmarop]

Hello,

I am a new member in the forum and I will need your help.

I use the following code. I want to make Replace only in the case which there is a whole word in a part of a cell, but not in part of specific characters.

Example: In the code i want to replace the word “to” but replaces all the words that contains “to”. For example in the word together lets only the characters gether, and in the word tonight lets only the characters night etc.

Please Login or Register  to view this content.

Thank you in advance,

Regards,
Dimitris

[sktneer]

Try this......

Please Login or Register  to view this content.

[MickG]

Change :- oNameFalse = "to" to oNameFalse = " to " and perhaps replace to :- " "

[stnkynts]

Did you try putting a space before and after the word "to"? Like this:

Please Login or Register  to view this content.

[dmarop]

Hi,

Thank you all for your help.

Dimitris