- Joined
- Sep 2, 2011
- Messages
- 1
- Reaction score
- 0
I currently have a column that contains both First and Last Names. Some first names have multipal names and some surnames have multipal names. Below is some sample data:
Jean Michael BURGES
Bill HARRIS
Willow VAN GRATH
Lisa jane VAN DE BERG
I need a way to get a column that contains the First Name (not ALL CAPS) and a column for the Surname (which is identifyed by the ALL CAPS)
I have tried making some functions based on what I have read in previous threads without any luck. I have also found them hard to debug. Any help is greatly appreciated.
Jean Michael BURGES
Bill HARRIS
Willow VAN GRATH
Lisa jane VAN DE BERG
I need a way to get a column that contains the First Name (not ALL CAPS) and a column for the Surname (which is identifyed by the ALL CAPS)
I have tried making some functions based on what I have read in previous threads without any luck. I have also found them hard to debug. Any help is greatly appreciated.