Matt...thank you for the solution! Just to clarify, Edit/Replace fields will work on a lookup or on your entire database. It is very important that you do the lookup just for the contacts whose field data you wish to change before using Edit/Replace fields, so only those contacts get edited.
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.