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.

Welcome to the forum.

1. =LEFT(A1,SEARCH(" ",A1)-1)
2. =PROPER(A2)

Thank you very much!

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.

Hi,

Try:
This formula will also handle any leading or end spaces.

Thank you very much Colin! It's worked for me.