Which function is used to remove leading, trailing, and duplicate spaces from a text string?

The standard spreadsheet function TRIM removes all spaces from a text string except for single spaces between words. It strips out leading and trailing spaces.