Excel Text to Column function
The text to column function allows you to split data from a single cell into a multiple cells. Ideal for data which has been downloaded or provided by third parties and requires amendments prior to being useful.
Highlight the data to be split and locate the “Text to column” button on the Data tab of the main ribbon.
The Convert to Text wizard will launch with the following options: –
The data in Column B has now been split to the three adjacent columns.