Watch the demo 

(You may experience a delay while the demo is loading.)

Storing certain types of information, such as an address, in one cell might limit what you can do with that information. For example, you can't filter or sort by just a part of the address, such as by country or city. However, if you split the address so that the different parts — street address, city, region, postal code, country — are in their own columns, you have many more options for working with the information. Watch this demo to see how to make your addresses uniform, and then use a wizard to automatically split a single column of addresses into multiple columns — one for each part.

• You can't split empty cells.
• If the cell is a merged cell, you can't split it. Instead, you unmerge the cell. That's explained in a separate demo Merge cells or combine their content.
• If you want multiple cells below a title cell, you don't split cells below the title to achieve that effect. Instead, you merge the title cell with other cells to spread the title across the cells below it.
• If you want to "split" a line into two lines in the same cell, you add a line break. Press ALT+ENTER at the point where you want to break the line.

How to do it (text version):

• Merge or split cells or cell contents
• Split names by using Convert Text to Columns

 Problems watching the video? Try our troubleshooting tips.