← Back to Text functions

Text.Start

This function retrieves the initial count characters from the given text and returns them as a text value.

Syntax

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

About

This function retrieves the initial count characters from the given text and returns them as a text value.

Explanation

Retrieve the initial 5 characters from the text "Hello, World" using the Power Query function MText.Start. The result will be "Hello".