If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reference different lines in the same cell
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 |
#2
|
|||
|
|||
Reference different lines in the same cell
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 |
Thread Tools | |
Display Modes | |
|
|