Hi Jeffrey,

If the export format is Excel, there is no access to the separator as it isn't used. Blank is valid for Excel exporting. Only if the CSV option is selected will the separator be available.

Can you give an example of a Department code value that you wanted to export that is giving a strange result? I have seen some values get re-interpreted by Excel because Excel thinks it knows what the value should be and is actually wrong.

If you try exporting to CSV, try editing the exported file with Notepad or Word instead of Excel. That way, you could determine if the Export process is getting the Dept value correctly and Excel is mis-formatting the value, or if the raw export value is wrong.