As Richard said, the report is essential. With it, if something does get messed up (and you do not have a backup to revert to) it is a often relatively simple to fix the errors. For example, Pennsylvaniowa can be searched for and replaced with Pennsylvania. Frequently there are only a handful of names that need followup correction but people freak out when they see results like Californialifornia and don't realize the same process that created the problem can also fix it. Gary Templeman -------------- Original message -------------- > Global replace can be most helpful with a little forethought. Laura's > example would have been more successful had the find been more selective > such as: ", IA " (comma, space, IA, space) with the Case Sensitive box > checked. It may be necessary to run it a second time with the find as ",IA > " (comma, IA, space). And don't forget to include the comma in the replace > field: ", Iowa" (comma, space, Iowa). One should never run a global replace > without the Create Report of Changes box checked. The listing will > identify any incorrect changes and allow you to correct them. > > Richard Rands