Easy way to remove Microsoft Word formatting from rich text fields?
When I export my data from Creator into Excel, I notice that the rich text form fields contain a lot of unnecessary Microsoft Word formatting code embedded - such as...
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
etc.
Is there any way to clean this mess up, other than going into each individual record and using the remove formatting button?