Replacing a space character

[nickcrispini]

I want to replace a space character with no space. So if I had two words such as 'Hello World' I would it to be replaced with 'HelloWorld'.

I previous have replaced characters with a simple function:

Function replaceChar(text)

text = Replace(text, "at", "@")
replaceChar = text

End Function


Is this possible.

Thanks.

Nick

[magus]

It's simple:

Function replaceSpace(text)

text = Replace(text, " ", "")
replaceSpace = text

End Function