The TRIM function will reduce the spacing between words down to a single space. You can also use the TRIM function in Excel to remove unnecessary spaces between words in a string. Result: 'apples' Clean Up Spacing Between Words Let's look at some Excel TRIM function examples and explore how to use the TRIM function as a worksheet function in Microsoft Excel:īased on the Excel spreadsheet above, the following TRIM examples would return: =TRIM(A1)
