Data Cleansing

[bcu_xl]

Does anybody have any tips for large data set cleansing in excel. I work with data that originates from many different places like data warehouses, webpages, various applications. A lot of clutter comes along with it like non printable characters, spaces, html, unicode and many other things that throw off macros. Things that I already use: trim, clean, substitute, replace, 'pasting blank', forcing re-calculations. What are some other strategies for cleansing data?

 

[FDibbins]

Depends what your data looks like? Without seeing samples, its a bit like asking - my car makes funny noises, how can I stop them?

 

[JoeMo]

This is a duplicate thread - prohibited by forum rules.