View original (French)

Can we remove line breaks in a cell in Calc?

Tinpro Posted messages 2 Registration date   Status Member Last intervention   -  
 Justine -
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

  1.
    tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    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
    9
    1. Dlya59
       
      Thank you for this tip that was very helpful to me. Best regards.
      0
    2. Justine
       
      Thank you a thousand times. I had started watching my hair fall for 2 hours on that cursed manipulation that I couldn't find!!!!
      0
  2. navigo
     
    There may only be an automatic line break,
    Check in Format Cell tab Alignment.
    0
  3. Tinpro Posted messages 2 Registration date   Status Member Last intervention  
     
    Hello, I just checked and there are no line breaks.
    0