Text.Range

Syntax

Text.Range(text as nullable text, offset as number, optional count as nullable number) as nullable text

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.

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / Text Functions / Text.Range