Text.Range
Text.Range(text as nullable text, offset as number, optional count as nullable number) as nullable text
Returns the substring from the text text
found at the offset offset
. An optional parameter, count
, can be included to specify how many characters to return. Throws an error if there aren't enough characters.
Find the substring from the text "Hello World" starting at index 6.
Usage
Text.Range("Hello World", 6)
Output
"World"
Find the substring from the text "Hello World Hello" starting at index 6 spanning 5 characters.
Usage
Text.Range("Hello World Hello", 6, 5)
Output
"World"