Splits text into parts at a comma, any other character, a regex match or every N characters, and puts each part on its own line. Double split cuts every part again, so “name=Ann;age=31” becomes a table with names in one column and values in the other. Where to split, Double split and the rest are in Options, under the boxes.
This is what the page does before you change anything: apple, banana, cherry comes out as three lines. Trim is on, so the space after each comma goes too. For a list separated by semicolons, tabs or pipes, open Options and type that character in Split character; \t stands for a tab and \n for a new line.
Sort puts the parts in order as they come out. The months example under the box splits “8. August, 3. March” and the rest, then sorts them by number from 1. January to 12. December.
Set Split mode to Double split. Split 1 cuts the text into rows and Split 2 cuts each row into columns. With ; for Split 1 and = for Split 2, name=Ann;age=31;city=Oslo becomes three rows of two columns in the Table tab. With \n and a comma, the same works for simple CSV.
The comma split doesn't know about quotes, so “Smith, John” in quotes still becomes two columns. For CSV with quoted fields, the CSV to JSON converter reads it properly.
In Options, set Split type to Fixed length and type the number of characters per part in Split length: 160 for SMS-sized pieces, 5 to cut abcdefghijklmnop into abcde, fghij, klmno and p.
It counts characters, not words, so a part can end in the middle of a word. An emoji counts as two characters and can be cut in half, which leaves a broken symbol at the end of one part and the start of the next.
In Options, type a full stop and a space in Split character, and set Prepend to - . “First point. Second point. Third.” becomes three lines that start with a dash. The split eats the full stops, except on the last sentence, which has no space after it.
When the text is already in a cell:
=TEXTSPLIT(A1, ",") does it with a formula.=SPLIT(A1, ","). Both write into the cells to the right, so keep those empty.For the way back, from a column to one line, use Join Text.
The character that marks where one piece of data ends and the next begins. In "red,green,blue" it's the comma; in a TSV file it's the tab; in most lists it's the line break. Pick one that never shows up inside the data itself, or a value like "Smith, John" gets cut in two.
Make every line a part, then wrap or rejoin the parts.
Cut text into pieces of the same number of characters.
Split at the end of each sentence and put a dash in front.
Split simple CSV into rows and columns with Double split.
Turn a comma-separated list into quoted array items.