RegEx to eliminat white spaces form a string

Hello,
Could anyone please advise, how to eliminate spaces from a string using a VBA code?

Example:
a 022 .a22 Convert into: a022.a22.

Note, the string can be of variable length.
Thanks

Hi plans, any specific reason why you want to use RegEx for this?

No, any other solution would be great.
Thanks.

First an example how to do it with Regex,

Please Login or Register  to view this content.

otherwise, try,

Please Login or Register  to view this content.