macro to remove space in numerical numbers

I have many numbers with Spaces in Sheet1 that is imported in Col A:Z

See eg below

211 359 223 262 223 222
(232 156 336) (221 822 613)


I would like a macro to remove these so that I can format the numbers with a thousand seperator


It would be appreciated if someone can provide me with code to do this

I have managed to write code remove spaces between numbers

Please Login or Register  to view this content.

Thanks Erwin