Excel Remove text after string for multiple possible strings

user_14267310 0
Viewed 64

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?

excel-formula excel
1 Answers

EDIT

You may try any one of these, as shown in the image below, edited since what JvdV Sir has mentioned does make sense.

• Formula used in cell B1

=REPLACE(A1,SUM(IFERROR(FIND({"DEV","BA"},A1),0)),255,"")

• Formula used in cell C1

=SUBSTITUTE(A1,LOOKUP(9^9,FIND({"BA","DEV"},A1),{"BA","DEV"}),"")

FORMULA_SOLUTION

user_81625200
Related