=PROPER(SUBSTITUTE(A1," and",""))
Ok, that is one approach, but note that it may be Bob Smith and Carol Jones, so Bob and Carol is more representative and more likely to be typed into the phone (one point of origin).
=PROPER(SUBSTITUTE(A1," And"," and")) ??
Bookmarks