Find and Replace Multiple Values in Excel using VBA Macro

This tutorial explains how to find and replace multiple values in excel using VBA. VBA Code to find and replace values in column or range is very simple and helpful in completing the task quickly.

[lucilleli]

You are a lifesaver! Please never stop making basic VBA videos like this! You are helping a lot of idiots like me to save time!
I was going to nest a lot of "IF ISNUMBER SEARCH" but it reached the limited lol
This is a much elegant way! Thank you!

[robertofreire]

Text in Portuguese, translated by google ... Dear friend, I don't know what part of the world you are from, but it helped me a lot with this tip! Thank you so much!

[ElianderOkame]

I was looking for this method for some time. Thank you for sharing

[sheilapatel]

thank you so much for creating this formula! It has helped me immensely and saved so much time!

[arantxasanchis]

Very helpful video and explained clearly 👍🏼 In case we want to find the text “Mumbai” in one column say A and if present, replace the value in the column next to it i.e B with “MUM”

[ricardocalleja]

Thanks for sharing I used to speed up a process at work. !

[rookuu]

Oh My, Works became easier, Thanks for your tutorial, Love you.

[JimEdwards]

This video was outstanding... thank you so much! This was a life-saver for me this morning... really appreciate it!

[venkateswaraservice]

Thank you so much sir, i used in this way before I had using find and replace command around 24 replacement but now easily to replace

[mohamedgawad]

many thanks for the amazing code but i have question if i have multiple sheets and want to do this process in all multiple sheets many thanks in advance

[bartoszjaskula]

Hi, can you please paste your VBA code into comments section? Thanks

[MohAboAbdo]

Thank you very much, great video and special explanation.

[gsssbibipurschoolpatiala]

thanks very inspiring..pls share more macro videos.

[owenlau]

Thank you for your videos, they are very helpful! quick question, what does lookat:=xlpart do?

[padmakarbhosle]

How we can use this ..if we have replacement data in same file another sheet ?? The steps need ..
Do i need to enter steps before for loop or inbetween

[binhubonetti]

Sub Macro1()

For i = 1 To 50


Selection.Replace What:=Cells(i, 3).Value, Replacement:=Cells(i, 4).Value, _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False

Next

Worksheets("Sheet1").Cells(1, 1).Select

End Sub

[VyTran-kgqf]

Thank you very much for this simple and useful tutorial. I wanna ask one more thing that how to create the button, I create one but when I click on it, nothing happens

[ramsah]

nice Video, please suggest how to replace the data in Visio as per excel data

[TienNguyen-kydx]

really? You made your viewer enter the VBA code word by word manually?

[shellysvarghese]

Will You be teaching Excel VBA? If yes then please let me know. Thanks