TRIM

The TRIM function removes unnecessary spaces in a string. Use it together with the PROPER function to clean your data.

=TRIM(Text)

or…

=TRIM(B3)

=TRIM(“Hello World”) = Hello World

Take a look at the video to see how it works!