Re: [libreoffice-users] Calc: How to concat CTRL+ENTER to a string?

2015-04-11 Thread James E Lang
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+ENTER

Re: [libreoffice-users] Calc: How to concat CTRL+ENTER to a string?

2015-04-10 Thread libreoffice-ml . mbourne
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.

[libreoffice-users] Calc: How to concat CTRL+ENTER to a string?

2015-04-09 Thread William Drago
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 to

Re: [libreoffice-users] Calc: How to concat CTRL+ENTER to a string?

2015-04-09 Thread Gary Collins
Hi,try: =CONCATENATE(Target Balance  CHAR(10) Assuming  E2*100 % Growth)   /Gary From: William Drago wdr...@suffolk.lib.ny.us To: LibreOffice List users@global.libreoffice.org Sent: Thursday, 9 April 2015, 12:17 Subject: [libreoffice-users] Calc: How to concat CTRL+ENTER to a string

Re: [libreoffice-users] Calc: How to concat CTRL+ENTER to a string?

2015-04-09 Thread Stefan Weigel
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