Hi William,
Am 09.04.2015 um 13:17 schrieb William Drago:
> =CONCATENATE("Target Balance Assuming ", E2*100, "% Growth")
>
> I want everything after "Target Balance" to appear in the second
> line of the cell so that the cell looks like this:
>
> Target Balance
> Assuming xx% Growth
First, you do not need to use CONCATENATE. You can just use the
&-operator for concatenating strings. However, you can use the
CONCATENATE function, as well, if you want. ;-)
For a line break, take the ASCII character no. 10.
e.g.
="Target Balance Assuming" & CHAR(10) & E2*100 & "% Growth"
Cheers,
Stefan
--
LibreOffice - Die Freiheit nehm' ich mir!
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
