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


   lines as list,
   optional lineSeparator as nullable text,
) as text


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: