In these two examples, the TRIM function will reduce the spacing between words down to a single space.
Let's look at an example of how to use the TRIM function to clean up the spacing between words in Excel.īased on the spreadsheet above: =TRIM(A1)
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)
