To summarize:
- Select the cell that you want to split into two parts.
- Click on the "Data" tab in the ribbon at the top of the Excel window.
- Click on the "Text to Columns" button in the "Data Tools" group.
- In the "Convert Text to Columns Wizard" that appears, select "Delimited" and click "Next".
- In the next screen, select the delimiter that separates the two parts of the cell. In your example, it looks like a comma (",") is used. Make sure the preview pane shows the correct separation of the two parts.
- Click "Next" and then choose the data format for each column. In your example, the first column should be formatted as "General" and the second column should be formatted as "Text".
- Click "Finish" and the cell will be split into two parts.
If you need to split more cells in the same way, you can select the range of cells and follow the same steps.