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.