Remove Space in Cells
Hi Rebecca,
There is a function called TRIM. It removes all spaces from a text
except single spaces between words.
If your texts start at A1, use a blank column, eg Column B and insert
=TRIM(A1)
Copy down to the end of your text cells.
You could then select all the trimmed cells in column B, copy, select
A1, Paste Special, Values, then delete the contents of column B.
Regards - Dave.
|