Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Libre calc - insert line or paragraph break in text cell

I'd like to insert a line or paragraph break inside a cell that has text using regular expression (which I'm new to).

eg. From: Reference Lidia

To: Reference Lidia

I've tried (With regular expression box ticked): Find: Reference Replace: Reference \n and Replace: Reference \n\n

What am I missing?

Libre calc - insert line or paragraph break in text cell

I'd like to insert a line or paragraph break inside a cell that has text using regular expression (which I'm new to).

eg. From: Reference Lidia

To: Reference Lidia

I've tried (With regular expression box ticked): Find: Reference Replace: Reference \n \n and Replace: Reference \n\n

What am I missing?

Libre calc - insert line or paragraph break in text cell

I'd like to insert a line or paragraph break inside a cell that has text using regular expression (which I'm new to).

eg. From: Reference Lidia

To: Reference Lidia

I've tried (With regular expression box ticked): Find: Reference ticked):

*Find: Reference

Replace: Reference \n and \n* and Replace: Reference \n\n

What am I missing?

Libre calc - insert line or paragraph break in text cell

I'd like to insert a line or paragraph break inside a cell that has text using regular expression (which I'm new to).

eg. From: Reference Lidia

To: Reference Lidia

I've tried (With the following (with regular expression box ticked):ticked), none have worked:

*Find: Reference

Replace: Reference \n* and Replace: Reference \n\n

What am I missing?