Hi,

I'm using excel 2003 and I'm looking for a way to manually or automatically
run auto correct on startup or after pasting. The thing is that I'm importing
large amounts of data and using text to columns to sort it out and
everythings fine, but the data comes from different places and does not
always match very well. Since it's important that for instance "St. Peters"
from one source and "Saint Peter's" from another source can automatically be
changed to the same "Saint Peter's" I'm looking for something with auto
correct here.

As of now I'm searching through the data for matches to change them manually
the one and the same.

The only thing it would take was if there was a way to initiate auto correct
manually on pasted data, cause then i could just take a day and add all the
changes to auto correct and then it would do the job for me.

Oh, i'm constantly overwriting old data with newer, pasting, so this is not
a one-time operation, cause if it was i could live with it but I really need
this.

Thanks
/Mitch