M Query - Text Transformations (to be checked)
Convert text to a number: Text.From([column_name])
Convert a number to text: Number.ToText([column_name])
Check if a value is a data type: if (Value.Is([column_name], Int64.Type) then Number.ToText([column_name]))
Trim text: Text.Trim()
Concatenation: Text & " " & More Text
Text ends with: Text.EndsWith([column_name], "text")
Text starts with: Text.StartsWith([column_name], "text")
Replace text: Text.Replace([column_name], "text to replace", "replace with this text")