Forum Discussion
Help! Removing a Space in Excel
TRIM() will remove only leading & trailing spaces but OP wants to remove from middle of sentence. So, TRIM() shouldn't work here.
"TRIM() will remove only leading & trailing spaces but OP wants to remove from middle of sentence. So, TRIM() shouldn't work here."
Not true!
Oh yes! May be TRIM() signature has been updated. Thanks for pointing it out. However, OP has some other character in his string.
We don't know whether the non-breaking space is present in the original data, or it is produced by the forum software (since HTML displays consecutive spaces as one).
Unlike the VBA function Trim, the worksheet function TRIM has always reduced multiple spaces to single ones inside a string.
Anyway, the OP might use
=TRIM(SUBSTITUTE(D1:D12000, CHAR(160), " "))
(substituting the appropriate range, of course)
