Find/replace text in D-F from B

[richiwatts]

First le me confess that I posted this on another forum but the answer I got required knowledge above my head.

I have a list of names in column B
In columns D-F I have sentences and the person's name is somewhere in the sentence.
I need to be able to surround the name with teh html code <b> and </b>

John Smith
Did you see John Smith at the party?

Would give me
Did you see <b>John Smith</b> at the party?
Could that be done with a Macro?

Rich

 

[TonyJollans]

The Swedish function names were changed in 2010, but the changes have been undone in SP1 "because of customer feedback". See

http://support.microsoft.com/kb/2551525

for full details.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[richiwatts]

Ah, thanks