Data in each cell should represent 1 thing (i.e. one ‘City Name’  or  one ‘Country’).

If various fields are pushed into 1 cell then learning Excel’s -Text To Columns- feature will save you many hours of work!

 

Watch my YouTube video

 

Crazy Data Cleanup Uses Text to Columns

This crazy solution required several steps including Excel’s famous ‘Text to Columns’ feature.

 

Subscribe to my YouTube channel and learn more!

See my free templates here!

Post a comment