Remove Extra Spaces Between Words in Power Query M

Collapses repeated spaces inside a text value down to a single space, in addition to trimming the ends.

Text TransformationsBeginnerspacestextcleaningwhitespace

Power Query M code

let
    Source = YourTable,
    Cleaned = Table.TransformColumns(Source, {{"ColumnName", each Text.Combine(List.Select(Text.Split(Text.Trim(_), " "), each _ <> ""), " "), type text}})
in
    Cleaned

Notes

Text.Trim only removes leading/trailing spaces; this also fixes double spaces in the middle of the text.

Requirements

A table with a text column that may contain repeated spaces.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Remove Extra Spaces Between Words.