Video 00023 TEXT TO COLUMNS to parse data

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!

Leave a Reply

Your email address will not be published.