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.

text to column - 1

Highlight the data to be split and locate the “Text to column” button on the Data tab of the main ribbon.

text to column - 2

The Convert to Text wizard will launch with the following options: –

text to column - 3

text to column - 4

text to column - 5

The data in Column B has now been split to the three adjacent columns.

text to column - 6