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....

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!