Find and replace multiple values in one cell from list

Hi, I have the below code in the attached file. What I am trying to do is find and replace multiple values contained in one cell. Looking at the file, I want the company names in column A replaced with the values in column D which represent a list of the company names in column C. See cell B25 for example. I have this code written but it only replaces the first value found and deletes the rest. I would appreciate any help. Thanks in advance.

Please Login or Register  to view this content.

Hello,

Use this code and run the procedure, "ReplaceStrings"

It will place the results in column B then just copy and paste.

Please Login or Register  to view this content.

Thanks

For the safety

Please Login or Register  to view this content.

Reg A25, you have carriage return inbetween names, so it is working properly.

Thank you all. So, So helpful.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Thanks, I never knew how to do that