A quicker way to trim?

[Leon V (AW)]

I have some csv data output as a text file with some (loads of) extra spaces in it. I can get a find replace loop to take out all the double spaces in the range almost instantly:

Please Login or Register  to view this content.

however once that is done all the cells still have a preceeding space so i use:

Please Login or Register  to view this content.

which takes ages to run as it is cycling through a lot of cells, anyone know of a way to speed this up? maybe some way of aplying trim to a range rather than one cell at a time.

[Norie]

Add an extra column, fill it with trim formulas that refer to the description column.

Then copy the new column and paste special values over the description column.

Finally delete the new column.

[AB33]

A couple of days ago, similar request was asked and Nilem came up with these few lines. This is not my code.

Please Login or Register  to view this content.

[JasperD]

Try setting at the top of your code :

Please Login or Register  to view this content.

and then at the end of your code

Please Login or Register  to view this content.

Please click the * below if helps