Thanks to all who replied. what I'm using:
="Target Balance" & CHAR(10) & "Assuming " & $E$2*100 & "%
Growth"
No need for the CHAR(13).
-Bill
On 4/10/2015 3:54 PM, libreoffice-ml.mbou...@spamgourmet.com
wrote:
James E Lang - jim+...@lang.hm wrote:
On a Windows platform I use &CHAR(13)&CHAR
Thank you, Mark. I also don't have a MAC so on that score I was speaking
theoretically.
--
Jim
-Original Message-
From: libreoffice-ml.mbou...@spamgourmet.com
To: users@global.libreoffice.org
Sent: Fri, 10 Apr 2015 12:56
Subject: Re: [libreoffice-users] Calc: How to concat CTRL+
James E Lang - jim+...@lang.hm wrote:
On a Windows platform I use &CHAR(13)&CHAR(10) [CR+LF] instead of just &CHAR(10)
[LF] which I use on a Linux platform or just &CHAR(13) [CR] which I would expect to use on
a MAC platform
Those are the conventions for plain text files on those systems.
Al
Hi,try: =CONCATENATE("Target Balance" & CHAR(10) & "Assuming " & E2*100 & "%
Growth")
/Gary From: William Drago
To: LibreOffice List
Sent: Thursday, 9 April 2015, 12:17
Subject: [libreoffice-users] Calc: How to concat CTRL+ENTER to a str
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, y
All,
To place two lines of text in a cell I type the first line
then press CTRL+ENTER and type the second line. I am trying
to do this in an equation and don't know how.
Here's what I have:
=CONCATENATE("Target Balance Assuming ", E2*100, "% Growth")
I want everything after "Target Balance"
