How does one add a linebreak in a cell using an iPad. I tried wrapping text but it wouldn’t work any other solutions?


2 Answers 2


Per David Wreesman:

each line needs to be in quotes, with &char(10)& in between each line.

For example, ="Dear Jane,"&char(10)&"I love you."&char(10)&"Love, Tom" would turn into:

Dear Jane,
I love you.
Love, Tom


Or add <br> at the end.

E.g. this is line a. <br> this is line b which becomes

this is line a.
this is line b.

Not the answer you're looking for? Browse other questions tagged or ask your own question.