Quote Originally Posted by José Augusto View Post
Try this
=SUBSTITUTE(SUBSTITUTE(A1,"(name)",C1,1),"(name)",D1)
I am using this but it doesn't work. It is still changing first (name) field not second.