Ask Your Question
0

How does one force a carriage return in calc cell? In Excel you force Line Breaks by (Alt Enter).

asked 2018-12-26 23:49:25 +0200

FiveStarPaintingOfOmaha gravatar image

updated 2018-12-27 23:18:06 +0200

m.a.riosv gravatar image

How does one force a carriage return in calc cell? In Excel you force Line Breaks by (Alt+Enter). Ex. You have a cell where you want to force a line break inside the cell.

Rather than accepting how the word wrap may format the cell, you want it to look like this:

John Doe Jane Smith Fname Lname

Thank you,

Don Matulek

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-12-27 00:24:25 +0200

Lupp gravatar image

While editing text in a Calc cell Ctrl+Enter inserts a hard line break.

(If you want to get line breaks inside calculated text results, you need to concatenate the text with a ...& CHAR(10) &... in the correct place.)

edit flag offensive delete link more

Comments

That worked great! Thank you Lupp! :)

FiveStarPaintingOfOmaha gravatar imageFiveStarPaintingOfOmaha ( 2018-12-27 00:29:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-12-26 23:49:25 +0200

Seen: 103 times

Last updated: Dec 27 '18