Highlight the cells under Breakfast. Click the Data tab and select the Food data type from the Data Types gallery. Click the Insert Data button on the right side of the cell.

In this formula, "|" is the vertical glyph character (enclosed in double quotes) often accessed by pressing Shift or Fn at ...

Look for it on the Data tab. Instead of pressing Enter, click Flash Fill in the Data Tools group. SEE: Explore 6 ways to save time using Flash Fill in Microsoft Excel.

Excel Ideas helps you extract the key information from a spreadsheet, but there's currently a limited range of insights available and some data formatting may be required.