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 (case sensitive).
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 (not case sensitive).
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


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