Episode 417 - Parsing Addresses
Sometimes you have a single column with several fields joined together. For example, you might have city, state, zip code in a single column. Episode 417 shows how to break this data into three columns using the Text to Columns command.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Labels: text to columns