I use Jeff's method all the time in SSIS, except I use a vertical tab as the "unlikely" character.

REPLACE(REPLACE(REPLACE(LTRIM(«Column»)," "," " + "\v"),"\v" + " ",""),"\v","")