Lines.ToText

Updated on

Lines.ToText is a Power Query M function that converts a list of text into a single text using a specified lineSeparator. The function returns a single text with the specified lineSeparator appended to each line.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Lines.ToText(
   lines as list,
   optional lineSeparator as nullable text,
) as text

Description

Converts a list of text into a single text. The specified lineSeparator is appended to each line. If not specified then the carriage return and line feed characters are used.

Other functions related to Lines.ToText are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/lines-totext