NumBreak() function to find the first number or text in a string


Version: 2026

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-32179


The NumBreak() function returns the postion of the first number or text in a string.

Syntax NumBreak(str$[, offset])

Examples 

NumBreak("abc123") =; //returns 4
NumBreak("1.34km") =; //returns 5
NumBreak("abc123def456", 7) =; //returns 10