Title: Remove Spaces in Excel - Easy Excel Tutorial
Headings: Remove Spaces
Remove Spaces
Content: Remove Spaces in Excel - Easy Excel Tutorial
Remove Spaces
The TRIM function in Excel removes leading spaces, extra spaces and trailing spaces. Use the SUBSTITUTE function to remove all spaces or non-breaking spaces. 1. The TRIM function below removes 2 leading spaces, 3 extra spaces and 2 trailing spaces. Note: the TRIM function does not remove single spaces between words. 2. To get the length of a string, use the LEN function. Explanation: the LEN function counts 2 spaces, 2 characters, 4 spaces, 3 characters and 2 spaces.