You could try selecting your range, then CTRL+H (Replace).
Find What = " " (spacebar), leave "Replace With" blank. Click Replace All.

Rgds,
Andy