I have the need to have a formula in B1 that looks at the contents of A1 and then displays a specific line of text that exists in A1
For Example:
A1 has the following:
REPLACE & LOANER
NEW CAD = 04/19
DELIVERY ABORTED 04/08 ON LOANER
I want cell B1 to display the contents of line 3 - "NEW CAD = 04/19"
To note. Upon creation of A1, these line are not wrapped. I seperate each line using Alt-Enter
For Example:
A1 has the following:
REPLACE & LOANER
NEW CAD = 04/19
DELIVERY ABORTED 04/08 ON LOANER
I want cell B1 to display the contents of line 3 - "NEW CAD = 04/19"
To note. Upon creation of A1, these line are not wrapped. I seperate each line using Alt-Enter