Forum Discussion
Help! Removing a Space in Excel
Hi group. Need some help here. I have 12000 records that need to have a space removed. Precision T3600 (Dell) As you can see, there is more than one space between 3600 and (Dell) I need to...
"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)
