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: Commonly the TRIM function on its own removes the unwanted spaces, between the words or at the beginning or end of the text string. Well in some situations it is found this fails to work. And in a computer, a space in two words is not categorized as a blank area but as a character. And there is more than one type of space character. In Web pages, one space character that the TRIM function won’t remove is non-breaking space. So if from the Web pages you have imported or copied data than in this case you might not be able to remove extra spaced with TRIM function if they are created by non-breaking spaces. So here know what you need to do if the Excel trim not working, but before moving further check out recognize the differences between non-breaking and regular spaces. [cta- excel -repair-lite labl=”recover lost Excel data”]
How To Fix Excel TRIM Not Working Issue? 1# Remove Entire Spaces Including the Spaces Between Words
If you don’t want any spaces between the words and in a formula you were using TRIM then use SUBSTITUTE. Here check out how to use SUBSTITUTE formula.