About
Use this tool to divide a piece of text into two or more columns. You can also use a new line to split text. Please keep in mind that you have to tell us what the delimiter is, which could be a comma, a space, or any other valid character. Columns must be separated by the same "delimiter" and have the same format, or the data will not be extracted and split correctly. Excel's concatenate function can take a lot of time to undo. When you want to separate a single-column text, this tool can help.
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, JamesResult
Column 1
Brown Davis Smith
Column 2
Paul Mark James
Split by new line
This puts a line feed (\n) where the delimiter was. Choose this if you want to break a text into separate lines.
Example: Split by new line using comma (,) as delimiter.Alaska,California,Florida,Hawaii,Indiana,KentuckyResult
Alaska California Florida Hawaii Indiana Kentucky
Related Tools
- Concatenate Text - Combine/merge two documents by concatenating texts line by line.
- Extract Column - Get a specific column from a delimited text.
- Swap Columns - Swap two columns from a delimited text.