Please I need help

Hi,

To remove leading and trailing spaces from your data, use the Trim function. First, go to the Transform Data page, select the Region column, right-click, choose Transform, and select Trim.

I made a YouTube video on this issue. If my solution helps you, please subscribe and like the video at
https://youtu.be/2H-DASuXF6A 

Thank You

Hi Ennygreat, if you also have spaces between words - you can do this:

Result

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WUlBwLC0uKUrMyUxUitWJVgrNyyxJTVHwzsxLT8nPBQspKPilliuAQFRqYk5iXgpUVCE4tSgJpC0WAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    Ad_RemovedSpaces = Table.AddColumn(Source, "Removed Spaces", each Text.Combine(List.RemoveMatchingItems(Text.Split([Column1], " "), {""}), " "), type text)
in
    Ad_RemovedSpaces