On Thu, May 4, 2006 08:34, Dan Lewis wrote: > On Thursday May 4 2006 09:57 am, Ville Mattila wrote: >> Hello list members, >> >> Is there any special character I could use to add a line feed to a >> string in a formula? I tried \n and some other common codes, but >> couldn't get it working. Is a multi-line content at all possible on Ooo >> Calc? >> >> Ville > > For the cell or cells you want to do this, Format those cells: > 1) Format > Cells > Alignment (tab) > Wrap text automatically. (This is in > the properties section at the bottom left of the Format Cells window.
And then you could use something like: =CONCATENATE(A1;CHAR(13);B1) -- Scott --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
