How to do LEFT/RIGHT/some other formula to return only top part of text from a box?

[Jyggalag]

Hi all,

I have a lot of cells that look like this:

Now, what I would like, is to have a formula that returns ONLY the top part of cell A3

I have separated the texts by pressing ALT + ENTER and then typing:

Test 1
Test 2
Test 3

instead of

Test 1 Test 2 Test 3

Is there a way in which I can get a formula to recognize this and only return the top part of the cell?

Thank you all!

Kind regards,
Jyggalag

 

[Jyggalag]

Solution here!

Excel Formula: Extract first line of cell

www.extendoffice.com

 

[RoryA]

=LEFT(A3,FIND(CHAR(10),A3)-1)

should do it.

 

[Jyggalag]

=LEFT(A3,FIND(CHAR(10),A3)-1)

should do it.

Also this. Thank you so much Rory! :D

 

[JvdV]

Alternatively:

=@TEXTSPLIT(A1,CHAR(10))

Or;

=TEXTBEFORE(A1,CHAR(10))

 

[shinigamilight]

=REPLACE(A1,FIND(CHAR(10),A1),95,"")