Only Capitalize First Letter & Delete Last Name

[zulhfreelancer]

Hi guys,

I need some help here. I have about 1000 subscribers name & email list here. I want to do some housekeeping where:

1. I want to remove 'last name' (in this case, Smith is the last name and I only want John to be there).

2. I want to only capitalize the first letter and did not want ALL CAPS records like JOHN SMITH.

Any Excel shortcuts to settle this?

Thank you.