Find and replace inside strings containing various names

[audioman]

I have a Word document which includes many instances of each of the strings shown below. Of course name1, name2 and name3 are actually individual first names.



name1, name2
name1, name2, name3

I'm looking for a macro which with change each of the above strings to
name1 and name2
name1, name2 and name3

Thanks for your help

[macropod]

You can do that with a wildcard Find/Replace, where:
Find = ,([!,^13^l]@[^13^l])
Replace = ^32and\1

No vba required.

[audioman]

Thanks for your answer. However, I didn't provide enough information. The document format is:

First Item: some variable information
Second Item: more variable information
Third Item: still more
Fourth Item: even more
Fifth Item: name1, name2 (or name1, name2, name3)

The above pattern repeats 5 or 10 times in the document. Your code does a great job at inserting the "and" as I requested. However, it also places the "and" in other places in the document, like at the beginning of each new line. I'm going to see if I can work with your suggestion but would appreciate any additional help.

[macropod]

It would probably be impossible for a Find/Replace, and even for a macro, to identify with certainty when you do or don't want a particular comma replaced. The Find/Replace works 100% with the sample data you have posted so far. Obviously, though, if you have a sentence like:
First Item: some variable information, but not all
there's no way to know the comma's not one you want to replace.

I don't see how the F/R could possibly insert 'and' at the beginning of a line, unless that line begins with a comma (which would be quite unusual).

[audioman]

Thanks for the code. I made a typo when transferring the code you provided. When I corrected my error, it worked beautifully.
Thanks again, I really appreciate your expert help and knowledge.