Keeping style when exporting to Excel
My data base has a surname field that is calculated to appear in capitals. Since Excel doesn't support styles, I made a script to copy the calculated information from that field to another text-only field. When I export the text-only field to Excel, it still doesn't appear in all caps. Is there a way to preserve the capitalization? Thanks for any and all help!