Can we remove line breaks in a cell in Calc?

Hello everyone,

Quick question, I would like to know if it is possible in Open Office Calc to remove line breaks in a cell, in general.

I need to integrate a supplier's price into our management software and the descriptions are on 3 lines which my software cannot handle.

EX: Price from a cell of my supplier:
"Rubber-steel stamp,
Ø 70 x 45,
with threading"

What I would like:
"Rubber-steel stamp, Ø 70 x 45, with threading"

I specify there are 8000 references so I need to do this in bulk.

Thank you in advance for your replies.

3 answers

  • Votes
  • Date
  • Descending date
  1. Hello,
    Try this:
    Select a cell
    Find and Replace (or ctrl+F)
    More options >> Check Regular expressions
    In the Find box, type \n
    In the Replace with box, type one space
    Click on replace
    1. Thank you for this tip that was very helpful to me. Best regards.
    2. Thank you a thousand times. I had started watching my hair fall for 2 hours on that cursed manipulation that I couldn't find!!!!
  2. There may only be an automatic line break,
    Check in Format Cell tab Alignment.