=EMAILSPLIT
The EMAILSPLIT function splits a text string containing one or more email addresses into a semicolon-separated list. You can optionally return a specific email address by its index in the list. Useful for processing multiple email addresses in outbound emails or workflow automation.
Syntax
Section titled “Syntax”=EMAILSPLIT(ReturnIndex; EmailAddressText)Parameters
Section titled “Parameters”-
ReturnIndex
-
The index of the email address to return.
-
0 returns the entire list of email addresses separated by semicolons.
-
1 returns the first email, 2 the second, and so on.
-
-
EmailAddressText
- The text containing one or more email addresses, separated by spaces, commas, or other delimiters.
How It Works
Section titled “How It Works”-
Parses the input text to identify individual email addresses.
-
Converts the list into a semicolon-separated format.
-
If a specific index is provided, only that email is returned.
-
Zero index (0) returns the full list in proper semicolon format.
Usage Notes
Section titled “Usage Notes”-
Supports email addresses separated by spaces, commas, or other common delimiters.
-
Formula functions are case sensitive and must be in all caps.
-
Useful for splitting multiple addresses for sending, reporting, or processing.
Examples
Section titled “Examples”=EMAILSPLIT(0; [email protected], [email protected] [email protected])// Returns: [email protected]; [email protected]; [email protected]
=EMAILSPLIT(2; [email protected], [email protected] [email protected])// Returns: [email protected]Keywords
Section titled “Keywords”EMAILSPLIT, split emails, email list, semicolon separated, email parsing, multiple email addresses, workflow formulas, outbound email, process field email, formula function