Reference different lines in the same cell

P

Panos

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
 
S

Stefi

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Autonumber field in Excel that behaves the same as Access 0
Embed the same Excel multiple times 0
Match and delete rows on two different sheets from reference numbers 4
VB Script reference cells for in current table? 1
External cell reference between two excel worksheets both in One Drive 0
Auto-Numbering in a Table in MS Word 1
absolute reference fill 1

Top