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

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: users+unsubscribe@global.libreoffice.org
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