I'm trying to format text so that there are line breaks in a generated string, but in such a way that it can work with Xcelsius.
I'm aware that you can use CHAR(10) in Excel to make a line break, but Xcelsius doesn't like the Char function.
Here is my formula: ="Item A:" & C39 & "Item B:" & C40
I want it to look like:
Item A:
Information from C39
Item B:
Information from C40
Does anyone know a way to have line breaks in a formula that Xcelsius can accept? The object is to get the text into a text box.
Thanks in advance!