VBA remove extra spaces

[neveu]

hello,

i have in a range several numbers that contain extra spaces and therefore these are recognized as text.

this is how the numbers would look : " 123.234.567"

could you please help me how to remove the extraspaces and the points (as otherwise this will also be recognized as text)?

thank you

 

[JoshMarquart]

Why do you leverage this? Is it to speed it up? I have 13,000 rows and this is taking a very long time to run. The .TextToColumns I have earlier in the program executes very quickly on the same rows...

With Application
.ScreenUpdating = False
.Calculation = xlCalculationManual
.EnableEvents = False

 

[JoshMarquart]

This made it run WAY FASTER!!!!!

I added steps to re-instate the updating/calculation/events before the script completes.

 

[MrKowz]

Why do you leverage this? Is it to speed it up? I have 13,000 rows and this is taking a very long time to run. The .TextToColumns I have earlier in the program executes very quickly on the same rows...

With Application
.ScreenUpdating = False
.Calculation = xlCalculationManual
.EnableEvents = False

As you found out, this dramatically speeds up the runtime. By turning off screen updating, the processor does not have to pause the macro, refresh the screen, and unpause the macro. By turning off calculations, it prevents Excel for wanting to recalculate every time a dependent cell is altered. And turning off events is a general toggle used to prevent things such as Worksheet_Change events from running.