I have a people picker field that is supposed to pull the current user of the infopath form's name and so far it works fine, but when exported to excel it also pulls in some extraneous characters that I don't want my users to see.
Is there a way to hide them? I am unable to set the default value of the field so I can't use the translate function and I am unable to write custom code in the form itself so any way aside from those would be helpful.
Here is an example of what I get on export: Doe, John***;#94***
The characters in the italics are the ones I need removed.