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.