I guess I should add that I am using FM Pro12 Advanced
Define an auto-entered calculation:
TextFormatRemove ( self )
and clear the "do not replace existing value..." check box.
Thanks Phil. Is there a way to make that retroactive for all previous entries pasted in? Or will this just handle entries made moving forward?
That will handle only new records, but you can use a form of this with the calculation option inside Replace Field contents to update existing records in a "batch" update. The only change to the calculation is to replace "self" with the actual name of the field.