How to remove letter from sequence in 1 column?

[TH123]

Hi all,

I'd like to get your support to solve this issue with given conditions below (column C = what I'd like to get). Thank you in advance.

1. If data in column B not found in column A => C = A
(example B1 = "ee" not found in column A1 = "dd" => C = "dd")
2. If data in column B found in column A => delete letter that found in column A
(example B2 = "ee" & found in column A2 = "dd, ee, ff" => C = dd, ff)

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C
1
2	dd	ee	dd
3	dd, ee, ff	ee	dd, ff
Data

Cell Formulas
Range	Formula
C2:C3	C2	=SUBSTITUTE(A2,B2&", ","")

 

[TH123]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C
1
2	dd	ee	dd
3	dd, ee, ff	ee	dd, ff
Data

Cell Formulas
Range	Formula
C2:C3	C2	=SUBSTITUTE(A2,B2&", ","")

Hi Fluff,

Thanks for your support. I've tried & result is what I want exactly.

Thank you again.

 

[Fluff]

You're welcome & thanks for the feedback.