To separate the contents of one Excel cell into separate columns, you can use the 'Convert Text to Columns Wizard'.
1. Select the range with full Column A.
2. On the Data tab, click Text to Columns.
The following dialog box appears.
3. Choose Delimited and click Next.
4. Clear all the check boxes under Delimiters except for the Other check box.
5. Click Next
6. Select Column data format.
7. Click Next.
Note: This example has commas and spaces as delimiters. You may have other delimiters in your data. Experiment by checking and unchecking the different check boxes. You get a live preview of how your data will be separated.
Result:
