Hi Piyush,
As there is no consistent format in words that needs to be deleted or retained. I suggest you two methods:
1. Case where you have exhaustive list of expected names. And use VBA macro to do string compare etc. Again this may not be right approach, I would on trial and error basis and tweak it accordingly.
2. Make a list of keys words that needs to be deleted like voice, data, security, TD:, Vx, N/a, Transformation etc. And use the VBA to run thru a loop to find and replace each of the listed words from your column C. You may need to keep adding words to the list as and when you see any new.
both the methods, may need to be revisited frequently to tweak to your needs. i do not think there would be any one time fix solution for the given situation.
Regards,
Prasad DN