Try this. Found it on the web (posted by an unknown user). I have used it and
it works great.

Remove Spaces
This is one of those functions  that, having built it, I wondered how I had ever
managed without! It came about because I wanted to build a list of email
addresses from a list of people's names. It was a big list! The plan was simple
enough... the email address would be firstname-dot-lastname-@-domainname.