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.
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
-
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 -
There may only be an automatic line break,
Check in Format Cell tab Alignment. -
Hello, I just checked and there are no line breaks.