Examples
INITIALS(CONCATENATE([First Name], " ", [Last Name])) : The first and last initials of the person identified by the current row. Equivalent to CONCATENATE(LEFT([First Name], 1), LEFT([Last Name], 1)). See also CONCATENATE(), LEFT().
INITIALS("International Business Machines") : IBM
INITIALS("Martin (Marty) Sandwich") : M(S
INITIALS("What you see is what you get.") : Wysiwyg
UPPER(INITIALS("What you see is what you get.")) : WYSIWYG
Syntax
INITIALS( some-text )
Arguments
- some-text (any textual type)
Return Value
Text: the first character of each word in some-text.
For the purpose of this function, a "word" is any sequence of non-spaces separated by one or more spaces. Punctuation does not separate words. Consequently, the returned "initials" may include non-letters if any "word" in the text begins with non-letters (e.g., a currency symbol, parenthesis, or quotation mark).