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
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.