Remove a text string in column B based on column C

[Pete2020]

I am very thankful to the Mr. Excel forum in providing right solutions.

my data consists 70k rows and would be helpful if you Provide a solution through VBA

1. Match every comma separated string of column C with Column B at each row level (C2 with B2)
2. If found - it should be remove the word along with Space and special characters or comma infront of it.
3. The output should be populated in Column D

Search and remove.xlsx
	A	B	C	D
1	School ID	Client Name	Location - match words and remove from column B	Expected Output
2	SC-001	Bachpan Play School, Lohara	MIDC Area,Darwha Road, Lohara, Yavatmal	Bachpan Play Schoo1
3	SC-002	Citizen Technical Institute Washim	Washim, Maharashtra, India	Citizen Technical Institute
4	SC-003	Absolute Spoken English, wardha, maharashtra, india	Hindinagar, Wardha, Maharashtra, India	Absolute Spoken English
5	SC-004	Kasturba Nursing college, KHS, Sevagram	Sevagram, Maharashtra, India	Kasturba Nursing college
6	SC-005	CP Goenka International School, Oshiwara | Andheri West	Oshiwara, Andheri West, Mumbai, Maharashtra	CP Goenka International School
7	SC-006	Sri Sri Ravishankar Vidya Mandir (SSRVM), Mulund, Mumbai	Sarvodaya Nagar, Mulund West, Mumbai, Maharashtra	Sri Sri Ravishankar Vidya Mandir (SSRVM)
8	SC-007	Saleem Zakerya Urdu High School Pusegaon	Pusegaon Main Rd	Saleem Zakerya Urdu High School
Sheet1

 

[Pete2020]

I Checked the macro. It is very crystal clear in removing the words as per the requirement

You are awesome and worth than Gold

Thank You.

 

[Peter_SSs]

Cheers. This sort of thing is notoriously tricky so you might still find some unusual results. Post back with details if this happens.