When you have a lot of data in a single cell in Excel, it can be difficult to read and make decisions based on that data. To help limit the amount of information in a cell, you can use the following tips:
Text to Columns
The Text to Columns feature can be found under the Data tab on the ribbon. It allows you to split text that is in one cell into multiple cells. This can be helpful when you have a lot of data in a single cell and you want to break it up into manageable chunks.
Highlight Data
Data Filters