Find and Replace Dynamic values

Guys,

Hope some one can help me. I have also attached the sample workbook.

I have got no. of data with multiple values in a one column (Industries) but i would like to set up a macro to find specific text value.
If excel find sepecific text vaule then create a new column(first instance only) and start replacing the vaule with unique text vaule and it will loop until end of last row.

Thanks in advance!