Good day guys,

I've another question here that closely related to this thread.

If I have these records in an Excel file (http://i.imgur.com/o13Cv.png),
what could I do to trim them to obtain just their first name?

1. Remove text after space (Smith) and obtain only John.
2. Remove text after space (SMITH) and obtain only John and capitalize only the front letter.
3. Maintain records that already capitalize it's front letter and doesn't have last name.
4. Capitalize front letter for name that doesn't have last name.
5. Normalize the case and only capitalize the front letter for name that doesn't have last name.

Thank you.