Removing spaces...

Hi all,

I have tried to use Trim to remove spaces but they dont seem to remove spaces within words/characters?

If I have a string such as: "Word1 Word2" etc. how can I remove the space IN BETWEEN the words?

Thanks

Mark

Code:

---

Replace(StringThatHasSpace, " ","")

---