Not a fully solution but just a thought

if you have a list of the autocorrects this is just 2 columns and in
your report just one entry per cell?

why not trysomething like

=IF(ISNA(VLOOKUP(A1,$C$1:$D$1000,2,FALSE)),A1,VLOO KUP(A1,$C$1:$D$1000,2,FALSE))

where your autocorrect list in c1:c1000

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=561375