When we have the contents of a set of data in a single table cell as the following figure:
i
We need to be separated in the column will do the following:
We click on the tab in the Data group Data tools will select Text to Columns and get the following contents:
And if we as in the case of data separated by a delimiter (tab separation) chooses the first choice Delimited.
In the case of the delimiter sign semicolon when properly select the window you will see the Data preview.
In the last window of the conversion, select the type of data (if necessary), and get the final result as follow figure shown
