Returns the first character in each word in a textual value.
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:
INITIALS("International Business Machines") returns
INITIALS("Martin (Marty) Sandwich") returns
INITIALS("What you see is what you get.") returns
UPPER(INITIALS("What you see is what you get.")) returns
WYSIWYG (see also
text- Any textual type.
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 (such as, a currency symbol, parenthesis, or quotation mark).