[FAQ000091]Can I add a line break to a pop-up message?

Q

Can I add a line break to a message in the "Show the following message as a pop-up" action?

A

If you specify a string for the "Show the following message as a pop-up" action,
just add a new line in the middle and it will be displayed as it should be.

If you want to specify a formula that concatenates strings and values instead of strings,
you can include a line feed in the string by concatenating cells with only a line feed entered in advance
at the position where you want the line feed in the concatenated string.

For example, if you enter the number "2" in the A1 cell, press Alt+Enter in the D1 cell to enter only a new line,
and specify the following formula as the "Show the following message in a pop-up" action,

="Today’s sale" & D1 & A1 & ""

The pop-up will look something like this.

"Today’s sale
2"


For more information on how the above formula works, please refer to this page.