Yes Macropod, I did read your answer; however, I don't believe you read my question . . . I understood what the previous responses were instructing, what I was saying prior to your last response was that no matter what I did . . . the verbiage MERGEFIELD would not appear when I inserted the field into the formula. It only appeared in my result below after I toggled back and forth twice after inserting the field.


For anyone else please that can help with my formula below, I would appreciate it . . .
This is my formula:


{IF{MERGEFIELD Request_Staff_Person}= "Mickey Mouse" "Minnie Mouse"}

This is the result: Mickey Mouse Minnie Mouse. . . instead of replacing Mickey Mouse with Minnie Mouse it is adding it to the same line. I need to replace the original name with the new . . . not add to it.

Many thanks in advance.

Which is precisely what the field coding Graham and I posted does - but only when implemented as described!

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]