remove spaces and points in cells with vba

[already]

Hi

I have to remove space and/or points from cells with a VAT number , IBAN and swift in exel sheets. (3 or 4 cells on the sheet) How can I do this with VBA.

Thanks in advance for your help

Regards

Al

 

[John Davis]

Hi John,

Wooooow!!!!!! This is it.

Many Thanks

Kind regards

Al

You're welcome. Glad it worked out for you, and thanks for the feedback.

 

[Trevor G]

Hi rustam and Welcome to the Board !!
I'm pretty sure it doesn't happen very often, that somebody's first post is an answer !!
Well done ! nice work !!

I agree with Michael M it isn't very often someone provides a solution as there first post. Well done and welcome to the Forum.