Power Query
published
Search
⌃K

Text.Range

Text.Range

Returns the substring found at offset.
function (optional text as nullable any, offset as number, optional count as nullable any) as nullable any

Description

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.

Category

Text.Extraction

Examples

Find the substring from the text "Hello World" starting at index 6.
Text.Range("Hello World", 6)
"World"
Find the substring from the text "Hello World Hello" starting at index 6 spanning 5 characters.
Text.Range("Hello World Hello", 6, 5)
"World"