=NUMSPLIT
The NUMSPLIT function retrieves all numeric values from a text string by removing non-numeric characters and returning the numbers as a semicolon-separated list.
Syntax
Section titled “Syntax”=NUMSPLIT(Parameter)Parameters
Section titled “Parameters”Parameter – The text string, field token, or value containing one or more numeric values.
How It Works
Section titled “How It Works”-
Evaluates the provided text or value.
-
Identifies all numeric values within the string.
-
Removes non-numeric characters between the values.
-
Returns the extracted numbers as a semicolon-separated list.
Usage Notes
Section titled “Usage Notes”-
Formula functions are case sensitive and must be written in ALL CAPS.
-
Useful for extracting multiple numbers from addresses, IDs, invoice data, or mixed text fields.
-
Returns numbers in the order they appear in the original text.
-
Semicolons are used to separate each extracted numeric value.
-
Can be combined with other text or parsing functions for advanced processing.
Example
Section titled “Example”=NUMSPLIT(123 Sample Street, New York, NY 10016)Returns
Section titled “Returns”123; 10016Keywords
Section titled “Keywords”NUMSPLIT, extract multiple numbers, numeric parsing, remove text, semicolon separated numbers, string parsing, workflow formulas, formula function