INITIALS()

First character of each word

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

See also

CONCATENATE()

LEFT()

MID()

SUBSTITUTE()

TRIM()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false