Excel Find & Replace Multiple Words or Characters at Once | 3 Methods VLOOKUP, SUBSTITUTE, VBA Macro

Download the featured file here: www.bluepecantraining.com/fin...
In this video I demonstrate how to find and replace multiple words at once in Excel. I explore three methods that can be used to achieve this:
00:00 Introduction
00:44 METHOD 1: Use VLOOKUP or XLOOKUP for whole word find and replace
03:23 METHOD 2: Use the SUBSTITUTE function for partial match find and replace
05:36 METHOD 3: Use a VBA Macro for whole word or partial match find and replace (lots of replacements)
------------------------

[@abulmezn]

I almost gave up before I saw your xlookup demo here …thank you Chester

[@DECCA789]

Thank you Chester. This is particularly useful for stuff I'm working on right now.

[@IvanCortinas_ES]

Excellent tutorial. Thank you for the VBA code Chester!!!

[@Luqmankhpalwaak]

Exactly what I was looking for

[@alexrosen8762]

Great tutorial 🙏

[@MrGarlic97]

exactly what i was looking for - thank you! also very good explanation :)

[@alexrosen8762]

Your examples are quite unique and really useful.

[@gerasimosbedragging3982]

The Vlookup just saved me about 100 hours of work, thank you.

[@AbdullaKhizamworld]

Would it be possible to show Sumifs Vba for more than 03 criteria or best Alternative for that. this is for Large Database like Debtors Statement where i would need to tally with collection.

[@janjoza8043]

every solution is based on having "text" in one column , but how to substitute character from area of cells(more columns)?
By the way, your way of explaining is quite good ,and simple, and I like it. Just this I missed there.

[@ceyhunkvrak7791]

👏👏

[@ASITHAKGLN]

Is it possible to insert a word in the middle of a sentence in Excel?

[@funeveryday8904]

Dear Thank you for great help, but VBA code not working with Turkish language characters such as I ğ ü ş ç ö. How can i fix that?

[@tanganhminh9138]

Can work ? Find and replace multi word in multi file with multi sheet in a folder

[@patrickvo3824]

for some reasons when i run macro it replaced everything including the exisiting database old text . can you please help