Title: Excel TRIM function - quick way to remove extra spaces
Headings: Excel TRIM function - quick way to remove extra spaces
Excel TRIM function - quick way to remove extra spaces
TRIM function - remove extra spaces in Excel
TRIM (text)
=TRIM (A1)
=TRIM (CLEAN (A1))
How to use TRIM function in Excel - formula examples
How to trim spaces in an entire column of data
How to remove leading spaces in a numeric column
=VALUE (TRIM (A2))
How to remove only leading spaces in Excel (Left Trim)
=MID (A2,FIND (MID (TRIM (A2),1,1),A2),LEN (A2))
How to count extra spaces in a cell
=LEN (A2)-LEN (TRIM (A2))
How to highlight cells with excess spaces
=LEN ($A2)>LEN (TRIM ($A2))
Excel TRIM not working
=TRIM (SUBSTITUTE (A1, CHAR (160), " "))
=TRIM (CLEAN (SUBSTITUTE (A1, CHAR (160), " ")))
Leading space: =CODE (LEFT (A1,1))
Trailing space: =CODE (RIGHT (A1,1))
=CODE (MID (A1, n, 1)))
=TRIM (SUBSTITUTE (A1, CHAR (9), " "))
Trim Spaces for Excel - remove extra spaces in a click
Available downloads
You may also be interested in

Content: From all appearances, the trimmed values are text strings, while we want numbers. To fix this, you can multiply the trimmed values by 1 (to multiply all the values in one fell swoop, use the Paste Special > Multiply option). A more elegant solution is enclosing the TRIM function in VALUE, like this: =VALUE (TRIM (A2))
The above formula removes all leading and trailing spaces, if any, and turns the resulting value into a number, as shown in the screenshot below: How to remove only leading spaces in Excel (Left Trim)
In some situations, you may type duplicated and even triplicated spaces between words to make your data better readable. However, you do want to get rid of leading spaces, like this: As you already know, the TRIM function eliminates extra spaces in the middle of text strings, which is not what we want. To keep all in-between spaces intact, we'll be using a bit more complex formula: =MID (A2,FIND (MID (TRIM (A2),1,1),A2),LEN (A2))
In the above formula, the combination of FIND, MID and TRIM calculates the position of the first text character in a string. And then, you supply that number to another MID function so that it returns the entire text string (the string length is calculated by LEN) starting at the position of the first text character.