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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks