Return the acronym from a text string

You can return the acronym for up to three words by using these formulas.
link - https://chandoo.org/wp/get-initials-from-name-excel-formula

 A
1FirstName LastName
2=LEFT(A1,1)&MID(A1,FIND(" ",A1,1),2) = F L
3 
4Abbreviate Three Words
5=LEFT(A4,1)&IFERROR(MID(A4,SEARCH(" ",A4)+1,1),"")&IFERROR(MID(A4,SEARCH(" ",A4,SEARCH(" ",A4)+1)+1,1),"") = ATW
6 
7Three With Spaces
8=IF(LEN(A7)-LEN(SUBSTITUTE(A7," ",""))=0,LEFT(A7,1),IF(LEN(A7)-LEN(SUBSTITUTE(A7," ",""))=1,LEFT(A7,1)&" "&MID(A7,(FIND(" ",A7)+1),1)&" ",LEFT(A7,1)&" "&MID(A7,(FIND(" ",A7)+1),1)&" "&MID(A7,FIND(" ",A7,FIND(" ",A7)+1)+1,1))) = T W S

Built-in Functions

FIND - The starting position of a substring within a larger text string.
IFERROR - The value or something else if it evaluates to an error.
LEFT - The first or left most characters in a text string.
LEN - The number of characters in a text string.
MID - The characters from the middle of a text string.
SEARCH - The starting position of a substring within a larger text string.
SUBSTITUTE - The text string after replacing instances of a substring.


User Defined Function

ACRONYM - Returns the first letter of each word.


Related Formulas

Remove one word
Replace one word with another
Return a substring
Return the first name from a full name
Return the last name from a full name
Return the second word
Return the words in reverse order


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top