Convert Full Name to multiple cells
Hi, I want to get FirstName, LastName, and Title as separate cells. The
data is not all exactly the same:
Napolitano, Mr. Frank
Curtian, Chris
I guess I need some sort of test for Title (Mr. Mrs.) (looking for a period?)
TIA!
|