Try this...

=IF(ISNUMBER(FIND(CHAR(10),A1)),LEFT(A1,FIND(CHAR( 10),A1)-1),A1)

where I have assumed your multi-lined text is in A1.

--
Rick (MVP - Excel)


"Hilvert Scheper" wrote in
message ...
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