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
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
Last edited by sandy666; 03-24-2017 at 07:47 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks