P.S. your solution for some reason is not working : excel cannot find the
data you specified...

"Pete" wrote:

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