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