December 4, 2020

TRIM function in Google Sheet

TRIM function is used to remove leading/trailing/consecutive multiple spaces between words in both Excel & Google Sheet.

In below example, your strings in column A contain leading/trailing/consecutive multiple spaces between words.

By using TRIM function all leading/trailing/consecutive multiple spaces between words have been removed in column B 

=TRIM(text)

Remember the TRIM function won’t remove the single space between words.

Leave a Reply

Your email address will not be published. Required fields are marked *