New Contributor

# Extracting first names in a list of names (FIRST NAME MIDDLE INTIAL.)

Good day everyone,

I would like to ask if is it possible to get the first names in a list of names with
this kind of format (First Name Middle Initial.).
Ex.

1. John Eduard B.                    (two-part first name)

2. May V.                                  (one-part first name)

3. Princess Jean Grace R.       (three-part name)

I want to get the first names only. However, some names have mutiple-part first names.

Sample list below:

Thank you

4 Replies

# Re: Extracting first names in a list of names (FIRST NAME MIDDLE INTIAL.)

Problem Solve:
=TRIM(LEFT(SUBSTITUTE(TRIM(A2), " ", REPT(" ", LEN(TRIM(A2)))), LEN(SUBSTITUTE(TRIM(A2), " ", REPT(" ", LEN(TRIM(A2)))))-LEN(TRIM(A2))))

# Re: Extracting first names in a list of names (FIRST NAME MIDDLE INTIAL.)

If you have Office 365, you can make it more readable by using the LET function like this...

``````=LET(
s,SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),
r,TRIM(RIGHT(s,LEN(A2))),
TRIM(SUBSTITUTE(s,r,""))
)``````

# Re: Extracting first names in a list of names (FIRST NAME MIDDLE INTIAL.)

Thank you sir. This formula also works.. May I know what is the meaning of letter "r" and "s" in this formula?

# Re: Extracting first names in a list of names (FIRST NAME MIDDLE INTIAL.)

With functions available in Beta version it's bit easier

``=TEXTBEFORE(A2, " ", -1)``