https://mycommunity.validity.com/t5/demandtools/line-break-in-concatenate-formula/m-p/2419#M1322 <P>I couldn't find this in any of the existing documenation, so posting this for anyone else that may have the same questions.</P><P>If you want to add a Line Break when using a CONCATENATE formula you can use the CHAR(10) character to add it.&nbsp;</P><TABLE border="1" width="100%"><TBODY><TR><TD width="12.373737373737374%">Example:</TD><TD width="87.62626262626263%">CONCATENATE("Name",CHAR(10),"John Smith")</TD></TR><TR><TD width="12.373737373737374%">Result:</TD><TD width="87.62626262626263%">Name<BR />John Smith</TD></TR></TBODY></TABLE><P>&nbsp;</P> Tue, 26 Nov 2024 16:28:03 GMT Murphybp79 2024-11-26T16:28:03Z https://mycommunity.validity.com/t5/demandtools/line-break-in-concatenate-formula/m-p/2419#M1322 <P>I couldn't find this in any of the existing documenation, so posting this for anyone else that may have the same questions.</P><P>If you want to add a Line Break when using a CONCATENATE formula you can use the CHAR(10) character to add it.&nbsp;</P><TABLE border="1" width="100%"><TBODY><TR><TD width="12.373737373737374%">Example:</TD><TD width="87.62626262626263%">CONCATENATE("Name",CHAR(10),"John Smith")</TD></TR><TR><TD width="12.373737373737374%">Result:</TD><TD width="87.62626262626263%">Name<BR />John Smith</TD></TR></TBODY></TABLE><P>&nbsp;</P> Tue, 26 Nov 2024 16:28:03 GMT https://mycommunity.validity.com/t5/demandtools/line-break-in-concatenate-formula/m-p/2419#M1322 Murphybp79 2024-11-26T16:28:03Z