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

Question

Good day everyone,I would like to ask if is it possible to get the first names in a list of names with&nbsp;this kind of format (First Name Middle Initial.).Ex.1. John Eduard B.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (two-part first name)2. May V.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (one-part first name)3. Princess Jean Grace R.&nbsp; &nbsp; &nbsp; &nbsp;(three-part name)I want to get the first names only. However, some names have mutiple-part first names.Sample list below:Thank you

subodh_tiwari_sktneer · Answer

JunRea&nbsp;&nbsp;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,""))
)

junrea · Answer

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

junrea · Answer

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

sergeibaklan · Answer

JunRea&nbsp;
With functions available in Beta version it's bit easier
=TEXTBEFORE(A2, " ", -1)

Forum Discussion

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

Share

Resources