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...