I figured out how to reformat from upper to proper in excel.
In FileMaker, If the data is entered all upper case or all lower case or whatever, this is data not a style as we have specific upper and lower case characters.
In FileMaker, you can change the data's case using Replace Field contents and one of the upper, lower or proper functions to get all upper case, all lower case or title case respectively.
I tried using TextRemoveStyle, TextAddStyle to reformat the data in the field, but when we export, it reverts to the original format.
It isn't clear what you mean by this; and there are some important distinctions to be made here.
One is the "raw" or as-entered style.
Another is the style that has been applied to the field when in layout mode.
Note that for the style set up for a field in layout mode, the very same field can be setup to display differently on different layouts. Or you can even display the same field on the same layout; but set up the display style differently.
Example, I have set up the second column to display as upper case.
In the second screenshot, the left column is the as-entered style; and the right columns show different display-styles.
It was a case of working too many hours, and not looking at the obvious solution.
Thanks Bruce. I should have just replaced using Proper(field). All is well this am.