How to remove a manual line break within a cell

[StevieBlueboat]

I have a long list of Reference Numbers with the corresponding Category in a cell. My objective is to remove the Manual Line Break (Col B) so the result will be a continuous string (Col C). (See image examples)

I have tried using LEFT and RIGHT formulas to separate them, but the manual line break still remains even if recombined by concatenating them.

It is a long list and would take ages if I were to enter each cell and backspacing to remove each manual line break.

[sokol92]

Try this:

=SUBSTITUTE(C1; CHAR(10);)

[Wanderer]

My suggestion would include a space

=SUBSTITUTE(C1; CHAR(10); " ")

PS:
With -9 in your formula in B1 it would work. With -10 the line,-break is copied also. But Substitute is better, as you don’t need to count characters.

[StevieBlueboat]

Thank you. That worked.
PS
Your PS also worked using 11 instead of 9.

[Wanderer]

(post deleted by author)