Find and replace in excel macros
Hi can any one please give me an idead how to I write a macro for finding the text from one colum row-by row, find it in the other column and replace it with a blank.
I knw how to record a macro, but after recording, I guess I will have to replace the hard coded values by variables and I am not very conversant with the syntax.
Re: Find and replace in excel macros
If you are not familiar with macro syntax. You can use programing language you are comfortable with to process excel.