How to find substituting value while find and replace in macro

  • Input (Sheet 1 Column A)Find (sheet 2 Column A)Replace With ((sheet 2 Column B)Output
    ABC CorporationCorporationCorpABC Corp
    ABC Incorporated Incorporated IncABC Inc
  • Thanks bro for the help.


    Works partially...


    i saw some of the rows are not replaced and Blanks .. Kindly check..... attached file for your reference.


  • I find that, those rows are not replaced because of Case sensitive.... please remove Case sensitive bro.. Thanks....