Find and Replace Dynamic values

[dpatel]

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!

[StephenR]

We need to know where the replacement values come from.

[dpatel]

Replacement values will be fix by user.

[dpatel]

Can anyone help me on intial query?

Thanks