This function returns a string value that has been stripped of all control characters.
Syntax
Text.Clean(text as nullable text) as nullable text
About
This function returns a string value that has been stripped of all control characters.
Explanation
Eliminate line breaks and other control characters in a text string by using the Power Query MText.Clean function. For example, MText.Clean("ABC#(lf)D") will output "ABCD".