Title: How To Fix Excel TRIM Function Not Working Issue?
Headings: How To Fix Excel TRIM Function Not Working Issue?
How To Fix Excel TRIM Function Not Working Issue?
How Trim Function Works In Excel?
How To Fix Excel TRIM Not Working Issue?
1# Remove Entire Spaces Including the Spaces Between Words
Here check out how to use SUBSTITUTE formula.
2# Remove Non-breaking Spaces
Follow the below-given instruction:
Removing non-breaking spaces
=TRIM (SUBSTITUTE (C1,CHAR (160),CHAR (32)))
How The Formula Works:
3# Considerations
4# Remove Space When Excel Says There Are No Spaces (but you see them!)
Follow the steps to remove spaces from Excel cell.
FAQ:
Conclusion:
Margret

Content: See the cell A2 in the screenshot,
Locate entire ” ” (in the inverted commas detect the gap by clicking space key on the keyboard)
And replace them with “” (detect no gap, you need to replace it with nothing)
The instance number will left blank as we need everything to be replaced
So this is trick that you can use to remove spaces when the TRIM function is not working. 2# Remove Non-breaking Spaces
You can remove the non-breaking space from the line of text by making use of TRIM, SUBSTITUTE, and CHAR functions. As inside the TRIM function, the SUBSTITUTE and CHAR functions are nested. And you can type the formula into the worksheet by using the functions dialog boxes for entering the arguments. Follow the below-given instruction: First, copy line of the below text that contains many non-breaking spaces between the words non-breaking and spaces, into the cell ( for example C1)
Removing non-breaking spaces
Then click cell C3 (this is the cell where the formula for removing the spaces will be placed)
And type the below-given formula in the cell C3 and hit Enter key
=TRIM (SUBSTITUTE (C1,CHAR (160),CHAR (32)))
The text line removing non-breaking spaces in Excel appear in cell C3 without any spaces between words
And click cell C3 for showing the complete formula> appears in the formula bar above the worksheet. In this way, you can remove space between the words when the Excel TRIM function won’t works. How The Formula Works: Each and every function performs its particular task: The CHAR function is used for entering ASCII codes for two different spaces into the formula – 160 & 32
The SUBSTITUTE function replaces entire non-breaking spaces between the words with regular spaces.