To separate the contents of one Excel cell into separate columns, you can use the 'Convert Text to Columns Wizard'. For example, when you want to separate a list of full names into last and first names.
If you have data in a cell that needs to be separated into multiple columns, Microsoft Excel uses the term Text to Columns. For example, if in an Excel table, cell A1 shows the name "John Doe" (first and last name), Text to Columns can split the first and last name to appear in multiple columns. This page explains how to use this feature.