Syntax

INITIALS(some-text)

Arguments

  • some-text (any textual)

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).

Examples

INITIALS(CONCATENATE([First Name], " ", [Last Name])) : The first and last initials of the person identified by the current row. If the First Name and Last Name column values are Martin and Sandwich, respectively, the expression is also equivalent to INITIALS("Martin Sandwich").

INITIALS("Martin Sandwich") : MS

INITIALS("Martin (Marty) Sandwich") : M(S

INITIALS("What you see is what you get.") : Wysiwyg

See Also

CONCATENATE(), LEFT(), TEXT_ICON()

Did this answer your question?