Conversions
Column Data Here……
Output as
or
Delimited Data Here……
0 items

Convert New Lines to Spaces

Flatten a column or a multi-line block into one continuous line.

Already set up: split mode is newline, join is none. Paste one item per line and press convert to join it up.

Examples

InputOutput
Simple apple ⏎ banana ⏎ cherry apple banana cherry
Realistic the quarterly ⏎ revenue report the quarterly revenue report

Why convert this way

Some fields only accept a single line. Search boxes, single-line config values and many API parameters break on line breaks, so flattening is the fastest fix for text copied out of a PDF or a wrapped document.

When you will need it

  • Text copied from a PDF that wrapped mid-sentence
  • Building a single-line search query from a list
  • Filling a form field that rejects line breaks
  • Collapsing a block into one value for a config file
Watch out: Flattening a paragraph that wrapped mid-word can join fragments incorrectly. Check the output for run-together words, and use the word counter if the count looks wrong.

What the settings do here

  • Split on newline — the tool reads apple⏎banana⏎cherry as 3 separate items.
  • Join with nothing — producing apple banana cherry.

Where this comes up

Copying from a PDF is the usual cause. The text wrapped at whatever width the document used, so every line break is an artefact of the layout rather than anything meaningful in the content.

Related conversions

Going the other way, or joining with something else entirely? The delimiter converter accepts any split and join pair including custom separators, and the index has the 16 ready-made ones.

Frequently Asked Questions

Why would I flatten multiple lines into one?

Search boxes, single-line config values and many API parameters reject line breaks. Flattening is the usual fix for text copied out of a PDF that wrapped mid-sentence.

Will flattening join words incorrectly?

It can, if the source wrapped in the middle of a hyphenated word. Check the output for run-together words before using it.