Using search with if function

[rnrmom11]

I need help to create a formula that will search if cell B contains the same text as in cell A. If it does, I want it to delete just the text in cell B that is the same as Cell A. Here's an example:

Cell A = PO Box 1252
Cell B = PO Box 1252, Des Moines, IA


Then Cell B should be updated to just "Des Moines, IA" and PO Box 1252 should be deleted from the cell.

TIA

[FlameRetired]

Hi rnrmom11. Welcome to the forum.

Try

=SUBSTITUTE(SUBSTITUTE(B1,A1,""),", ","",1)

	A	B	C
1	PO Box 1252	PO Box 1252, Des Moines, IA	Des Moines, IA

[sandy666]

Based on Dave's table, in C1: =IF(IFERROR(SEARCH(A1,B1)>0,0),SUBSTITUTE(B1,A1&", ",""),B1)
change last B1 to "" if you want leave C1 blank while this condition IFERROR(SEARCH(A1,B1)>0,0) is FALSE

edit:
btw. formula cannot delete anything