To allow autocorrect to run on pasted data without clicking in each cell.

[Michellephant]

Hello,

I am copying and pasting names and data into a worksheet with complex macros. A lot of the names are misspelled and need to be changed. To avoid interferring with macros in the sheet I entered the names into autocorrect so they correct themselves. This solved the problem a bit but the names do not autocorrect unless I click in the cell. Is there a way to run autocorrect on the whole spreadsheet??? Running spellcheck doesnt solve the problem as it points to every name, including those spelled correctly.

Thank you for your consideration,

Michelle

[mrice]

You might be better creating a lookup table with mispelled and correct columns and using a VLOOKUP function to correct.

Something like

=IFNA(VLOOKUP(A1,D:E,2,0),A1)

will change misspelled words but keep ones not identified as misspelled.