Dear experts

I have data in column D:D Header value is Source:

I have to align the values proper format like My target is CSV File But it has like CSV or CSV_File or CSV File so it got mis appropriate values of text in col
My target is CSV File from where find CSV
2nd target is Manual - CBT from where ever find CBT change as Manual - CBT
3rd target is Web Adi from where ever find Web or Adi or Web_Adi,wEb adi like
In 3rd condition main criteria is Web Adi MC_MT should not be change it should be as it is

Pls do needful find the attachment