Prev: How do I search for the second largest value in the array?
Next: More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, ..
From: Panos on 22 Apr 2010 06:01
Hi all,

I have an excel sheet were in some cells there are multiple lines created by
pressing "Alt + Enter".
Is it possible to reference each individual line within these cells
separately in a formula?

Thanks a lot
From: Stefi on 22 Apr 2010 06:44
To a certain extent yes. E.g. if A1 contains one Alt+Enter then
=LEFT(A1,SEARCH(CHAR(10),A1)-1) returns the content before Alt+Enter,
=RIGHT(A1,LEN(A1)-SEARCH(CHAR(10),A1)) after Alt+Enter.

--
Regards!
Stefi



„Panos” ezt írta:

> Hi all,
>
> I have an excel sheet were in some cells there are multiple lines created by
> pressing "Alt + Enter".
> Is it possible to reference each individual line within these cells
> separately in a formula?
>
> Thanks a lot
 | 
Pages: 1
Prev: How do I search for the second largest value in the array?
Next: More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, ..