ToolsAutocorrect

Roll your own.

I'm sure there are more cases than just your example so post back with more
details if you want code.


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 13:22:13 -0700, Jerry
wrote:

I have a column in which want to automatically control information entered.
As an example if someone enters XYZ I want it to automatically change to ABC.