Trimming Blanks using VB

[craig80]

Hi All,

I have a data set of about 20k rows, exported from a not so friendly DB, that has blanks all over. It is causing havoc with my VB and Dates!

Can anyone help me to TRIM all the data.

Ideally some VB just to pop into the clean up loop I have on for formatting.

Any advice would be great.

Thanks

Craig

 

[VoG]

See if you can adapt this http://www.mvps.org/dmcritchie/excel/join.htm#trimall

 

[craig80]

I have had a bash with this, some of the VB removes the space by specifying it as a CHR(160).

But it loops round forever, and isn't as pratical as I had hoped.

I am looking to transpose =TRIM(cell) into VB to cover =TRIM(Range), but dont konw where to start?

thanks

Craig