Hi Everyone,

I have phone number recorded in very messy way in column D1:D45000

some numbers have spaces inbetween

i.e. 029873 0982

How do I remove those spaces?

I tried going into Ctrl + F - Replace " " to "" but it did not work.


Help please~~

Thank you


Regards

James