Excel - How to remove part of text using conditional formatting?

Question

Hello,

I wanted to remove a part of text from a cell that is in another cell.

But I don't know how to write it in the conditional formatting exactly (I still have a problem with using dollars)

Please help

Thank you

Answer 1

You should use formula in Cells instead of conditional formatting.

=SUBSTITUTE(C2,B2,"")

Or

=TEXTJOIN("+",,TEXTSPLIT(SUBSTITUTE(C2,B2,""),"+"))

Answer 2

You cannot use conditional formatting to change the value of a cell, only to change the way it is displayed.

You can use a formula in another cell. For example in D2:

=SUBSTITUTE(C2, B2, "")

Fill down.

Please note that this will return DOG++FISH in D2, and +CAT+FISH in D3.

To get around this:

=MID(SUBSTITUTE("+"&C2, "+"&B2, ""), 2, 100)