← Back to Text functions

Text.End

This function retrieves a text value containing the last specified number of characters from the original text value.

Syntax

Text.End(text as nullable text, count as number) as nullable text

About

This function retrieves a text value containing the last specified number of characters from the original text value.

Explanation

Retrieve the final 5 characters of the text "Hello, World" using the Power Query function MText.End("Hello, World", 5). The result will be "World".