Prev: Importing a picture behind worksheet?
Next: how to use countif to incorporate filters
From: leanjinja on 15 Mar 2010 12:53


"Bretter99" wrote:

> For example: =concatenate(a1,a2,a3,a4) = ILIKEBEEFBURGERS, But I want it to
> put the result into a single excel cell like this:
> I
> LIKE
> BEEF
> BURGERS
>
> But i cant see how to manually insert a line break into my statement as in
> something like:
> =concatenate(a1,<line break>,a2,<line break>,a3,<line break>,a4,<line break>,)
> Any suggestions would be appreciated, thanks :P
From: leanjinja on 15 Mar 2010 12:56


"Bretter99" wrote:

> For example: =concatenate(a1,a2,a3,a4) = ILIKEBEEFBURGERS, But I want it to
> put the result into a single excel cell like this:
> I
> LIKE
> BEEF
> BURGERS
>
> But i cant see how to manually insert a line break into my statement as in
> something like:
> =concatenate(a1,<line break>,a2,<line break>,a3,<line break>,a4,<line break>,)
> Any suggestions would be appreciated, thanks :P

You could always use alt+enter - it just starts a new line within a cell.
From: Gord Dibben on 15 Mar 2010 13:07
=A1 & CHAR(10) & A2 & CHAR(10) & on and on

Make sure cell is set to wrap text.


Gord Dibben MS Excel MVP

On Mon, 15 Mar 2010 09:53:01 -0700, leanjinja
<leanjinja(a)discussions.microsoft.com> wrote:

>
>
>"Bretter99" wrote:
>
>> For example: =concatenate(a1,a2,a3,a4) = ILIKEBEEFBURGERS, But I want it to
>> put the result into a single excel cell like this:
>> I
>> LIKE
>> BEEF
>> BURGERS
>>
>> But i cant see how to manually insert a line break into my statement as in
>> something like:
>> =concatenate(a1,<line break>,a2,<line break>,a3,<line break>,a4,<line break>,)
>> Any suggestions would be appreciated, thanks :P

 | 
Pages: 1
Prev: Importing a picture behind worksheet?
Next: how to use countif to incorporate filters