Leaderboard

When using Quick Change on Fields that contain multiple values is you have to list all the values. For example if the Artist field has J. Scott Cambell, Jack Kirby. If you do a Quick Change to correct Cambell, and just typed J. Scott Campbell, the Artist would just contain J. Scott Campbell. The Jack Kirby entry would be erased. You could try to change it to J. Scott Campbell, Jack Kirby if you just had the one row. But if you have multiple rows, then they would all be set to the same value you entered (either just J. Scott Campbell or J. Scott C\ampbell, Jack Kirby. For the most part, the names with typos only occur a just one or a few rows. The best, easiest way I have found is to just type in the correction manually and then submit the corrections. PS when manually changing, I then to use Paste to insert the missing value as it would cause other names after it to be erased. Or I would copy the rest of the row, type the changes, then paste the info back. Or you could just copy the whole set of values to Notepad, make changes then paste it all back.