Remove all spaces from a string 1

[Binnit]

How can I create a function to search through a string and remove all spaces so that

"This string has 4 spaces"
becomes
"Thisstringhas4spaces"

I have read the help relating to the Instr function but not sure how to take it forward and remove the spaces.

Any ideas?



Happiness is...not getting what you want but wanting what you have already got

 

[Remou]

What you need is Replace:

Replace(ThisString," ","")

 

[MichaelRed]

If by "Space" you mean the literal space character (e.g. Chr(32), look up the REPLACE function and apply it accordingly. If you mean "White Space" as in all non printing characters, it is more convolouted.





MichaelRed

 

[Binnit]

Remou - worked a treat nice and simple

MichaelRed - thanks for your post but only the simple answer required at this time as per Remou solution.

Happiness is...not getting what you want but wanting what you have already got