how to insert line break in a formula

Joined
Feb 10, 2006
Messages
2
Reaction score
0
What is the way to write a formula which will produce the same result as entering Alt-Enter manually, i.e. if I need content of two concatenated fields to be on different lines inside the combined cell?

Example:

cell A1="string_1"
cell B1="string_2"

And I need cell C1 to be:
cell C1=
"string_1
string_2"

I tried c1="concatenate(a1, CHAR(10),b1)"
it doesn't work -- shows a little square between the values of a1 and b1 instead of makeing a line break.

Would appreciate ideas.
 
Joined
Feb 10, 2006
Messages
2
Reaction score
0
I found an answer myself. :)
It's necessary to have wrap text in a cell enabled - then CHAR(10) works as expected!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top