Eloquent solution squirrel man.

You could even make it more compact with
VB Code:
  1. Text1 = Join(Split(X, " "), "")

...