Скачать или смотреть Excel Find & Replace Multiple Words or Characters at Once | 3 Methods VLOOKUP, SUBSTITUTE, VBA Macro

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:

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍

Download the featured file here: https://www.bluepecantraining.com/wp-...

🕰️Timestamps
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)
------------------------

Here's the VBA code:

Sub MultiReplace()
Dim ListItem As Range
Dim ListToReplaceWithin As Range
Dim ListOfThingsThatWillChange As Range
On Error GoTo ErrorHandler
Set ListToReplaceWithin = Application.InputBox(Prompt:="Select the list you want to replace within:", Title:="Replace Items", Type:=8)
Set ListOfThingsThatWillChange = Application.InputBox(Prompt:="Select the list of items that you want to change:", Title:="Replace With", Type:=8)
For Each ListItem In ListOfThingsThatWillChange
ListToReplaceWithin.Replace What:=ListItem, Replacement:=ListItem.Offset(0, 1)
Next ListItem
Exit Sub
ErrorHandler:
Exit Sub
End Sub