data cleansing

[shankary]

how to clean data in a spread sheet in an efficient way?

 

[offthelip]

Load the entire spreadsheet into a Variant array, process the variant array and then write it back to the spreadsheet. Processing a variant array is usually about 1000 times faster than processing directly on the worksheet

 

[alansidman]

Look into using Power Query