Demo: Distribute the contents of 1 cell across multiple cells
Or download the demo.
(You may experience a delay while the demo is loading.)
Storing information, such as a full address, in one column can limit what you can do with that information. For example, you can't easily filter or sort by part of the address, such as country/region or city. However, if you break up the address into its parts — street address, city, state/province, postal code, country/region — one for each column, you can remove those limits. Watch this demo to see how to use the Convert Text to Columns Wizard to automatically break up a single column of full addresses into multiple columns.
How to do it (text version):
Problems watching the video? Try our troubleshooting tips.