As an example, you might copy business data from an online database only to find unwanted whitespace within the text strings ... between words. Excel's Trim function will remove all but one ...

It is used to fix irregular spacing in Excel. Where text refers to the text string ... And then use the TRIM() function to remove all spaces from both ends of the original text string.

Let us see these in detail. Remove spaces in Excel using the TRIM() function The TRIM() function is a text function in Excel that is used to fix irregular spacing. It removes all extra spaces from ...