Remove Unwanted Spaces using TRIM

Clean up leading, trailing and double spaces in imported text.

You will learn to

• Use TRIM to normalise spaces

How it works

TRIM removes spaces from the start and end of text and collapses repeated spaces between words into one. Extra spaces often break lookups and comparisons.

=TRIM(A2)