remove random spaces in a text string

[mariusescu]

I have a column with postal codes that come in two formats, with and without a space in the middle (L5N3M0, L5N 3M0).
I'd like to get rid of this space without having to go through it manually. So I'd need a function that does that, and I'd like to use this function in a macro.

Any help is much appreciated

thank you
m

[Andy Pope]

The REPLACE function can be used to strip text.

Please Login or Register  to view this content.

or you could combine JOIN and SPLIT

Please Login or Register  to view this content.

[mariusescu]

thanks a million Andy