Returns the first character in each word in a textual value.
Sample usage
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")
returns IBM
INITIALS("Martin (Marty) Sandwich")
returns M(S
INITIALS("What you see is what you get.")
returns Wysiwyg
UPPER(INITIALS("What you see is what you get."))
returns WYSIWYG
(see also UPPER()
)
Syntax
INITIALS(text)
text
- Any textual type.
Notes
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).