If this problem is a simple matter of different spellings, then instead of performing 42 individual search- and- replace operations, you can press the F7 key to spellcheck your entire worksheet or workbook. I'm working to have the spelling problems corrected at the affiliate offices in Europe, but in the meantime, is there an easier way to correct them than using Word's Search and Replace tool?Ī. To correct these spelling issues so the city names can be used to merge their data with our data, I perform 42 separate search- and- replace operations each week, which takes a lot of time.
I receive a weekly sales report from our European affiliate that has between 1,260 and 2,100 city names spelled using a native spelling that does not match what we use here in our offices (42 city names 'misspelled' 30 to 50 times each).
