Forum Discussion
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. ...
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?