How to delete all the words after the last "("in the excel table? Please give a formula! thank you

Yours is not unique. How to judge? You'd better judge by the article number.

If your data is in column A, then B 1 enter the formula.

=LEFT(A 1, FIND ("article number", A 1)-2)

Formula drop-down completed

If you want to complete it in column A, you can copy column B after the above formula is completed, right-click and paste it selectively, select a value and confirm. At this time, column B is not a formula, and the original column A can be deleted. ..