Demo: Distribute the contents of 1 cell across multiple cells

Worksheet with names and addresses in columns Play Demo Demo button

Or Down arrow 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):

Assistance Problems watching the video? Try our troubleshooting tips.

 
 
Applies to:
Excel 2007