how to append a multi-line text after a formula in

问题:

I can make an automatically calcuated value appear a cell using '=' operator. For example, when cell F20 is 200, I can enter in cell G20

=F20/10

Then, I see 20 in cell G20.

Now I want to add a note in cell G20 so that it appears

20
note 4)

I know I can do

=concatenate(F20/10,"   note 4)")

but this obviously shows

20   note4)

which is not what I want.
How can I put enter(new line) in the appended text in this case?

回答1:

You can use CHAR(10) which is newline:

=concatenate(F20/10,CHAR(10),"(note 4)")

Make sure you have 'Wrap Text' turned on for it to work.