To split cells in Excel, follow these steps:
- Click and drag from the first cell to the last cell in the column that you want to split.
- Go to the “Data” tab located at the top of the Excel Ribbon.
- In the Data Tools section, click the “Text to Columns” button.
- In the Convert Text to Columns Wizard, choose the “Delimited” option and click “Next.” This option is suitable when the text is separated by commas and spaces.
- Check both the “Comma” and “Space” delimiters, and then click the “Next” button. Delimiters are used to specify how the data is separated. You can choose any delimiter that suits your data set.
- Finally, click “Finish” to complete the splitting process.