vba to replace old words with new words in a column

[tonywatsonhelp]

Hi Everyone,

So I'm stuck with a problem,

I want to replace old words with new words in a column,

Now the problem i have is that If I try replacing "Bill" for example it not only replaces Bill, but also replaces those letters in any other word like "unbilled"

is there a way for me to be able to only replace the word if it is just the word?

so Bill to Sue would be:

so for example cell N10 might say "We told Bill, he should Be Billing Bob, but,Bill,Is Unbillable" to "We told Sue, he should Be Billing Bob, but,Sue,Is Unbillable"

I tried to show what I'm up against, Bill might be surrounded by either a space or a comer on either or both sides.

Currently i was a simple find and replace as below, but any way to do this will be fine

Range("N4:N1000").Replace What:=Oldvalue3, Replacement:=Newvalue3, LookAt _
        :=xlPart, SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False _
        , ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

please help if you can

thanks

Tony

 

[JoeMo]

Glad we could help.