Split Text by Character to Individual Lines

Divide text using any character or by any number of characters you want.

Split by:
characters
0 characters

Frequently asked questions

How do I split a CSV row into a list?

Choose Comma. Every value comes back on its own line, ready to paste into a spreadsheet column or a form field.

Can I split by a character that is not in the list?

Yes. Choose Another character and type the one you want, such as a pipe, a slash, a colon or a tab.

Should I split by a separator or by character count?

Split by a separator when the text already has one, such as a comma or a line break. Split every N characters when it does not, and you need equal-sized blocks, for example for fixed-width data or a line-length limit.

Does the separator stay in the result?

No. The character you split on is consumed, so each piece comes back without it.

What happens to empty entries?

They are dropped, so two separators in a row do not leave a blank line in the middle of your list.

Can I put the pieces back on one line afterwards?

Yes, with Remove or Replace Line Breaks, which joins the lines using whatever character you choose.