Parse Before Line Break
Josh O. wrote:
I could use some help making a formula to return all characters before a
carriage return [or an alt-enter or Char (10), depending on how you referr to
it].
The Cell has a lot of text in it and can have more than 1 carriage return in
it...
Any ideas?
=LEFT(A1,FIND(CHAR(10),A1)-1)
|