macro to replace text with new text in excel

[spastica]

I would like to create a macro that will search for values in a column, and replace them with new values accordingly.

for example, if the value in the cell is "xa" i would like to replace it with "ab", if it is "xo" i would like to replace it with "on" etc.

is there a way to do this with a macro, to loop through all records and replace accordingly?

sorry, if this is a simple question, i'm new to macros in excel.

 

[SkipVought]

spastica,

Turn on the Macro Recorder

Menu item Edit/Replace - enter find and replace string and execute

Trun off the macro recorder

Inspect your code. If you have trouble making it general, post back.



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884