\1
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.
Bookmarks