Thread: [Solved] vba to replace old value by target value search almost key words matching
View Single Post
 
Old 11-11-2015, 08:25 AM
manilara manilara is offline Windows 7 32bit Office 2007
Banned
  
Join Date: Apr 2015
Posts: 7
manilara is on a distinguished road
Default vba to replace old value by target value search almost key words matching
Dear experts

I have data in column 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.
Last edited by manilara; 11-11-2015 at 08:27 AM. Reason: reason