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
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.
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top