Remove everything after the numbers, or the first line.

[TCyber]

How do I remove everything after the last number in multiple cells?

CAV-011543 Limit the number of things that can be found in the cell, I do not need any of this info only what is above in the cell.

 

[TCyber]

The issue is the numbers are different in every cell and can fluctuate the number of digits, but the top line of the cell is all that I need.

 

[alansidman]

deleted.

 

[Cubist]

Try:

=LEFT(A1,MAX(TOCOL(FIND(SEQUENCE(10,,0),A1),3)))

 

[Scott Huish]

Since there's a line break, you could just go off of that.

=TEXTBEFORE(A1,CHAR(10))