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

[JunRea]

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

[#2]

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

[#3]

@JunRea 

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,""))
)

[#4]

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

[#5]

@JunRea 

With functions available in Beta version it's bit easier

=TEXTBEFORE(A2, " ", -1)