Skip to Content
0
Former Member
Apr 13, 2010 at 03:42 PM

Formula Line Breaks

47 Views

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!