Use Search and Replace - highlight all the cells, then Edit | Replace
(or CTRL-H). In the Find box type a single space, leave the Replace
With box with nothing in it and then click Replace All.

Pete