What is a formula to remove the whitespace from an Excel cell when trim doesn't work?
Fresh3 days ago
Mar 15, 202658972 viewsConfidence Score0%
0%
Problem
I have a table of Excel data that I copied from an html table in Internet Explorer. A column of table values all seem to have a space at the end of them, but won't remove it. When I paste-special the value of the result of the function, it still has the whitespace on the end. Could it be some other…
Error Output
Trim
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: What is a formula to remove the whitespace from an Excel cell when trim doesn't work?
Low Risk
Character 160 is a non-breaking space, a character designed to look like a space but still be part of the word, forcing the adjacent words to stay together. You can convert them to regular spaces and then use trim. Assuming the text is in , use:
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix