Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
This article describes the formula syntax and usage of the INITIALS function.
Description
Returns the initials of a given name or text string.
Syntax
INITIALS(text)
The INITIALS function syntax has the following argument:
- text - Required. The text string from which you want to extract initials.
Example
| Formula | Description | Result |
| =INITIALS("John Doe") | Extracts initials from the name "John Doe". | JD |
| =INITIALS("Alice Smith Johnson") | Extracts initials from the name "Alice Smith Johnson". | ASJ |
Errors
For a full list of formula errors, please read Formula errors.