Hi,

Say your names strated in A1 then enter this in the next blank cell in row 1

=PROPER(SUBSTITUTE(A1," and",""))

It converts Bob and carol to Bob Carol.

VBA Noob