Text.Range

Remarks

Text.Range returns a substring from text starting at the zero-based offset index. If count is provided, at most count characters are returned. If count is omitted or null, all characters from offset to the end of the string are returned.

If text is null, the function returns null. If offset is beyond the end of the string, an empty string is returned — not an error. If count extends beyond the available characters, all remaining characters are returned without error. This lenient boundary behavior makes Text.Range safe to call without pre-checking string length, though you should still validate that the returned value is not empty when presence of content is expected.

Text.Range and Text.Middle are functionally identical — both accept an offset and optional count. Text.Range tends to appear in manually written queries where "range" feels more natural, while Text.Middle is the name produced by the Power Query UI. Choose based on readability in context.

For extracting the beginning of a string, Text.Start is more expressive. For extracting from the end, use Text.End. For a single character, use Text.At. Use Text.Range or Text.Middle when you need to extract from the interior of a string.