Hi there,
Can I Please ask the following question;
Is it possible to create a Cell-reference (as a Formula) that will give me
just the first line of Text in a Cell?
Example: I have this Text in just One Cell:

(Variable) CUSTOMER NAME
Address Line 1
Address Line 2
Address Line 3
Etcetera
Etcetera

Then, in another Cell I now Only need the First Line ("CUSTOMER NAME"),
however many caracters are in that First Line.
Is this at all possible with "LEN", "LEFT", "MID" or a similar formula?
Many Thanks in advance for Your help,
Hilvert Scheper