split

Split Text

Use this tool to split a text into two columns or more. You can also split text by new line. Please note that you must specify the delimiter whether that be comma, space, or any valid character. Columns must be separated by the same delimiter and follow the same format or it will not properly extract and split the provided data. Undoing the concatenate function in Excel can be time-consuming. This tool can be handy when you're trying to unmerge a single-column text.

About


Use this tool to split a text into two columns or more. You can also split text by new line. Please note that you must specify the delimiter whether that be comma, space, or any valid character. Columns must be separated by the same delimiter and follow the same format or it will not properly extract and split the provided data. Undoing the concatenate function in Excel can be time-consuming. This tool can be handy when you're trying to unmerge a single-column text.

Split into columns


This is basically the opposite of concatenate text tool. It extracts each column and places them into individual cells.

Example: Split first name and last name into two columns using , (comma followed by space) as a delimiter.

Brown, Paul
Davis, Mark
Smith, James

Result

Column 1

Brown
Davis
Smith

Column 2

Paul
Mark
James

Split by new line


This replaces the delimiter with a line feed (\n). Select this option if you wish to break a text line by line.

Example: Split by new line using comma (,) as delimiter.

Alaska,California,Florida,Hawaii,Indiana,Kentucky

Result

Alaska
California
Florida
Hawaii
Indiana
Kentucky