Thread: Reference different lines in the same cell
View Single Post
  #2  
Old April 22nd, 2010, 11:44 AM posted to microsoft.public.excel.worksheet.functions
Stefi
external usenet poster
  
Posts: 1,841
Default 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