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):

Help Button Problems watching the video? Try our troubleshooting tips.

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language