With Excel, I need to find and remove some text from all cells in a column. Using the example below I need to remove all instances of DEV or BA in this column.

Example data in a column:
Dan Smith DEV
Bob Jones BA

This example work but not with multiple possible matches.

=LEFT(A1,FIND({"DEV"},A1)-1)

How can this be done with multiple possible matches?

CodePudding user response：

EDIT

You may try any one of these, as shown in the image below, edited since what