Bulk Find and Replace in Excel; How to find and Replace Multitude Values in Excel
Watch this video to find out about Bulk Find and Replace in Excel; How to find and Replace Multitude Values in Excel
Copy the code bellow;
Sub MultiFindNReplace()
'Update 20210826
Dim Rng As Range
Dim InputRng As Range, ReplaceRng As Range
xTitleId = "KafayatExcelCode"
Set InputRng = Application.Selection
Set InputRng = Application.InputBox("Original Range ", xTitleId, InputRng.Address, Type:=8)
Set ReplaceRng = Application.InputBox("Replace Range :", xTitleId, Type:=8)
Application.ScreenUpdating = False
For Each Rng In ReplaceRng.Columns(1).Cells
InputRng.Replace what:=Rng.Value, replacement:=Rng.Offset(0, 1).Value, Lookat:=xlWhole
Next
Application.ScreenUpdating = True
End Sub
*****************************
Please Like, share, and subscribe to my channel!
Watch, rate, share and Comment your favorite on satisfying videos
Leave a like if you enjoyed it and tell me what you think in the comments!
****************************
Please, support the original creators. All credits in this video
None of these images, music & video clips were created/owned by me.
This video is purely fan-made, if you (owners) want to remove this video, please contact me through the YouTube private messaging system. I will respectfully remove it.
*******************************