You can do this with AutoCorrect. Click TOOLS and select AUTOCORRECT OPTIONS
and add what you want to trap and what you want to replace it with.

A lot easier that writing code.
--
Kevin Backmann


"notthemacroman" wrote:

> I need a macro that when selected, will correct cell inputs.....
> ex. What I want in the column/row of cells is AAAA.
>
> What I have been given is AAA B, AA, AAAAA.
>
> I would like to correct these with a macro.
>
> Any help would be great, thanks.