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: As you see, the use of the TRIM function in Excel is easy and straightforward. Nevertheless, if someone wants to have a closer look at the formulas discussed in this tutorial, you are welcome to download the Trim Excel Spaces Workbook. Excel TRIM not working
The TRIM function is designed to remove only the space character, represented by code value 32 in the 7-bit ASCII character set. In the Unicode character set, there is one more space character called the non-breaking space, which is commonly used on web pages as the html character . The nonbreaking space has a decimal value of 160, and the TRIM function cannot remove it by itself. So, if your data set contains one or more white spaces that the TRIM function does not remove, use the SUBSTITUTE function to convert non-breaking spaces into regular spaces and then trim them. Assuming the text is in A1, the formula goes as follows: =TRIM (SUBSTITUTE (A1, CHAR (160), " "))
As an extra precaution, you can embed the CLEAN function to clean the cell of any non-printable characters: =TRIM (CLEAN (SUBSTITUTE (A1, CHAR (160), " ")))
The following screenshot shows the difference: If the above formulas do not work for you either, chances are that your data contain some specific nonprinting characters with code values other than 32 and 160.