Find and Replace Multiple Values in Excel - ALL AT ONCE!

🙏Thanks for all the feedback! Honored!
Please note I don't offer any troubleshooting beyond what the video illustrates.

Can we do the same but without using visual basic

Thank you so much its very helpful after spending hours and hours to find a solution for replacing values

Thanks !

Awesome

I found a workaround if you would like to change the formatting(colour/bold ex). For your key use the original data(eg. 154 /style you want to replace in the first column and in the second column use the concatenate function to add a unique suffix or prefix (xx154xx). After running the script use conditional formatting to edit the data containing your suffix (xx).

Hi is there a way to do this for styling only ?

This is great! Thank you! How would you change the code to not match the entire cell contents? Each of your examples were single words in the cell. I am trying to replace names within full sentences. Thanks again!

This is cool and you obviously know what you're doing, I think the issue I have is that I don't know how you put together the VBAS code, and therefore I don't feel like I learned anything here. Plus if you're going to set up the file the way you did with a key, then why not use an Xlookup to change the values? I bet that would be even quicker than the solution you provided. Again, not disrespecting your work, just didn't feel it had any value for me. Thanks.

Thanks very helpful for me

Doesn't work at all for me

Hi there, this worked perfectly first time, but I had to save my excel as a macro enabled one first. I did this on an excel saved on teams, which is linked to a MS form (where the data is coming from). 2 questions, how do I keep the MS form linked to my new 'macro enabled' excel, and how do you make the formula/macro automatic, or do you have to keep re-running it? I am trying to automate the answers I receive from my MS form, so that strings of text are automatically replaced by numbers (my key). thanks.

It didnt work for me. it only replaced few things. I dont know why it doesnt work for me...
996 45 HC
596 45 HC
F4H 40 HC
F20 20 HC
F30 30 HC

Thank you so much

Awesome

When I hit F5, my keyboard light is turning on. I cannot open kutools for excel. What to do, please help!

Thanks. It still works in 2022. As a few people have mentioned, keep a copy of the original data as undo/cntrlZ would not undo the replacements.

You're a genius man, thank you

Worked out thank you 👍🏻

Can this be used to change the format of the cell as well?

I am getting a runtime error 13
Please help