You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

Q. 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 ...