Page tree
Skip to end of metadata
Go to start of metadata

Syntax

SUBSTR(<string>; <start number> [; <length>])

Description

Returns a specific number of characters from a text string starting at the position you specify. If no length is specified, the rest of the string is returned. The first value in a string has the start number of 0.

When a string value is evaluated by the function and no characters can be returned, the returned value is an empty string.

When a null value is evaluated by the function, the returned value is null.

Examples

=SUBSTR(#Sheet1!B;4;3) returns the next three characters in a string starting with the fifth character

=SUBSTR(null;0,1)  returns null
Column1Start numberSUBSTR returns
Admin-Annabelle6Annabelle
Admin-Mark6Mark
Admin-Lucy5-Lucy
Admin-Joshua6;4Josh
Admin-Joshua0;5Admin
Admin-Maria11
<null>6<null>
  • No labels