How can I move a cell's second line to the end of the first? (turning it into just one line) For the entire column

[zap]

A conversion process from pdf has skewed some timecodes I put in a column. The last digit has been misplaced to the second line of every cell.

They should all look like this instead:

But instead of double clicking each cell, going to the end of the first line, then pressing DEL to fix it, is there a better way to apply this to the entire column? There’s around 3000 plus cells and doing it manually like that will kill me.

[LeroyG]

It does not seem to be this case, but in some instances you can select menu Format - Cells… - Alignment tab, uncheck Wrap text automatically, and OK.

There is a Wrap Text icon in the Formatting toolbar.

[JohnSUN]

Ctrl+H, Find regexp \n and Replace it to empty string

[zap]

Wow that is elegant. Replacing the line breaks with with nothing thus deleting them. Thank you so much, it worked!