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

%3CLINGO-SUB%20id%3D%22lingo-sub-3495912%22%20slang%3D%22en-US%22%3EExtracting%20first%20names%20in%20a%20list%20of%20names%20(FIRST%20NAME%20MIDDLE%20INTIAL.)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3495912%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%20everyone%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20like%20to%20ask%20if%20is%20it%20possible%20to%20get%20the%20first%20names%20in%20a%20list%20of%20names%20with%26nbsp%3B%3CBR%20%2F%3Ethis%20kind%20of%20format%20(First%20Name%20Middle%20Initial.).%3CBR%20%2F%3EEx.%3C%2FP%3E%3CP%3E1.%20John%20Eduard%20B.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20(two-part%20first%20name)%3C%2FP%3E%3CP%3E2.%20May%20V.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20(one-part%20first%20name)%3C%2FP%3E%3CP%3E3.%20Princess%20Jean%20Grace%20R.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B(three-part%20name)%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20want%20to%20get%20the%20first%20names%20only.%20However%2C%20some%20names%20have%20mutiple-part%20first%20names.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3ESample%20list%20below%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JunRea_1-1654947278160.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22JunRea_1-1654947278160.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22JunRea_1-1654947278160.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22JunRea_1-1654947278160.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22JunRea_1-1654947278160.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22JunRea_1-1654947278160.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22JunRea_1-1654947278160.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22JunRea_1-1654947278160.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22JunRea_1-1654947278160.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F379523i795C00BBCF241693%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JunRea_1-1654947278160.png%22%20alt%3D%22JunRea_1-1654947278160.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3495912%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3495937%22%20slang%3D%22en-US%22%3ERe%3A%20Extracting%20first%20names%20in%20a%20list%20of%20names%20(FIRST%20NAME%20MIDDLE%20INTIAL.)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3495937%22%20slang%3D%22en-US%22%3EProblem%20Solve%3A%3CBR%20%2F%3E%3DTRIM(LEFT(SUBSTITUTE(TRIM(A2)%2C%20%22%20%22%2C%20REPT(%22%20%22%2C%20LEN(TRIM(A2))))%2C%20LEN(SUBSTITUTE(TRIM(A2)%2C%20%22%20%22%2C%20REPT(%22%20%22%2C%20LEN(TRIM(A2)))))-LEN(TRIM(A2))))%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3495957%22%20slang%3D%22en-US%22%3ERe%3A%20Extracting%20first%20names%20in%20a%20list%20of%20names%20(FIRST%20NAME%20MIDDLE%20INTIAL.)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3495957%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1421046%22%20target%3D%22_blank%22%3E%40JunRea%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20Office%20365%2C%20you%20can%20make%20it%20more%20readable%20by%20using%20the%20LET%20function%20like%20this...%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DLET(%0As%2CSUBSTITUTE(A2%2C%22%20%22%2CREPT(%22%20%22%2CLEN(A2)))%2C%0Ar%2CTRIM(RIGHT(s%2CLEN(A2)))%2C%0ATRIM(SUBSTITUTE(s%2Cr%2C%22%22))%0A)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3495982%22%20slang%3D%22en-US%22%3ERe%3A%20Extracting%20first%20names%20in%20a%20list%20of%20names%20(FIRST%20NAME%20MIDDLE%20INTIAL.)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3495982%22%20slang%3D%22en-US%22%3EThank%20you%20sir.%20This%20formula%20also%20works..%20May%20I%20know%20what%20is%20the%20meaning%20of%20letter%20%22r%22%20and%20%22s%22%20in%20this%20formula%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3496290%22%20slang%3D%22en-US%22%3ERe%3A%20Extracting%20first%20names%20in%20a%20list%20of%20names%20(FIRST%20NAME%20MIDDLE%20INTIAL.)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3496290%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1421046%22%20target%3D%22_blank%22%3E%40JunRea%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWith%20functions%20available%20in%20Beta%20version%20it's%20bit%20easier%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DTEXTBEFORE(A2%2C%20%22%20%22%2C%20-1)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

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:

JunRea_1-1654947278160.png

Thank you

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

@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,""))
)
Thank you sir. This formula also works.. May I know what is the meaning of letter "r" and "s" in this formula?

@JunRea 

With functions available in Beta version it's bit easier

=TEXTBEFORE(A2, " ", -1)