Split Text into Columns

This Google Sheets feature allows splitting text based on the chosen delimiter and displaying the result across multiple columns (one per element).


Example of Use

To split the text from cells A1 to A30 and distribute it across multiple columns, select the cells and then click on "Split text to columns" in the Data menu:

google sheets split text columns png into

Then simply choose the right delimiter to correctly divide the text:

google sheets divide text columns png split into

To split text while keeping the original data, use the SPLIT function.