Macro to Split and Remove based on cell value

Hi,
This is my input:

Col A
asde,dsfts-qwsa/001,asdasd-qwsa,asdas
etert,ttyutt-tww/013,dgdd-tww,dsfsaa
.
.
.
.
.

Col B
qwsa
tww

In Col C.. I want the output to be as

asde,asdas
etert,dsfsaa

Requirement as a text:
I need a macro that removes the value in column A based on the value in Col B.
The data that the macro removes is always between the "," (comma).

Please Help.
Karthik

Thanks for the quick response.
No.
Data in Col B is already present.
The macro/formula should look for the string that is present in Col B in Col A and remove the data within the "," (comma).

Did u get me?

Originally Posted by sktneer

This can be easily done with the help of a formula,

Assuming that you have text in A2, then

in B2

Please Login or Register  to view this content.

In C2

Please Login or Register  to view this content.

Does it help?

Please find the attached excel.

Originally Posted by sktneer

No, I didn't get it.
Better you upload a sample workbook along with the expected output. Do you want to update data within the column A based on column B?
You need to clarify it.

Try the attached.