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...
If this is in a single column, for example in D1:D12000:
In an empty column, enter the following formula in the cell in row 1:
=TRIM(D1:D12000)
The formula result will spill down to row 12000.
Select the result, copy it, then paste as values over D1:D12000.
You can now clear the column with the formulas.
If the data are in multiple columns, you might use a macro (in the desktop version of Excel).
Let me know if you need that.