Exporting Worksheets To Text With Special Characters

[serioussam13x]

Hello,

I am trouble saving individual wordsheets as tab delimited in excel and keeping the special characters. It replaces the special characters with '?'. The characters are Chinese characters which I need in a dual process. I have a perlscript which picks up the tab delimited file and fires it off to another system. Does anyone know a way to export Chinese characters into a tab delimited text file by manually saving or even vba macro? Any help would be appreciated.

 

[BrianB]

Are you sure that the special characters are being changed, or is it that the target application cannot understand/display them ?

Generally text characters in files are saved as *code numbers* which are converted back to alphanumeric characters by the application it is opened in. Usually depending on which *font* is used there. You can see this by formatting a cell using Wingdings font then back to the original. Many of them will display "?" if it does not recognise the code. Plain Text editors like Notepad are not good at it . Could try opening the file in Word.

If the character is actually being changed, then it will look different when the file is imported back to Excel.

A way of checking the code of a character in Excel is to use a formula like :-
=CODE(MID(A1,2,1))

Hope this helps.