VBA to Search a Text String, Find a Value listed in another column and replace the text
Hey everyone I have a problem that I really could use your expertise on....
My problem is this... In Excel 2010 I have a column (let’s say column A) that is a series of text strings. What I need to do is similar to a vlookup+find/replace.
In column B I have a values that I want to find and then replace with the values in column C. The key is that I need the entire text sting to stay intact with only the specific value being changed. I have basic knowledge of VBA but I know it can be done. VBA is an ideal solution because my volume of text strings can be 50k plus lines... and I think this is beyond what can be written with standard Excel Formulas. Below is an example and I have attached an sheet with a more detailed example if you need it.
Thanks for the help in advance!!!
Column A (text string)-----Column B (Find Text)-----Column C (Replace with)-----Column D (next text string)
text1 text2 Denver text3 text4-----Denver------CITY-----text1 text2 CITY text3 text4
FINAL NOTE: I do NOT really need an “output” or Column D if it could simply replace the value in Column A while keeping the other part of the string intact that would work too.... Thanks again I look forward to seeing what you guys come up with!
Last edited by Jschrod303; 11-16-2012 at 08:08 PM.