how do I add a newline in app formula? I am ...

[zhujian_Tang]

how do I add a newline in app formula?

I am trying to use use App formula to add some long text in one field. Just wondering is there any way I can add new line in the long text.

For example, I want Value from Column A, B, C display in Column D. Instead of having

Value A Value B Value C in one line, can I have

Value A Value B Value C in three lines?

[Lynn]

Hi @zhujian_Tang What

are you trying to achieve. Could you explain your question a bit more thanks.

[Aleksi_Alkio]

Would you please describe your request little deeper, thanks.

[zhujian_Tang]

Hello All, I am trying to use use App formula to add some long text in one field. Just wondering is there any way I can add new line in the long text.

For example, I want Value from Column A, B, C display in Column D. Instead of having

Value A Value B Value C in one line, can I have

Value A Value B Value C in three lines?

[Aleksi_Alkio]

Yes it’s possible…

CONCATENATE([ColA],"

“,[ColB],”

",[ColC])

[zhujian_Tang]

@Aleksi_Alkio I will try now. Thanks a lot!

[Aleksi_Alkio]

You’re welcome