Special Character Problem In MS Excel

[Former Member]

Hi All,

I have a field like Ship to Name and value of that field is 'Fire Systems US - Northford ' .When we download this field into Microsoft excel we are getting like Fire Systems US âu20ACu201C Northford . Hear special character (âu20ACu201C) is updating insted of Hypen(-).

How can we download the the same ship to name with out any special character in Microsoft excel.

Please help me.

Thanks,

Venkat

[murtuza_chhatariya]

Which FM are you using for Excel download? Actually it should not happen and can be issue with FM. Have you checked if there is any SAP note for that?

Thanks,

Murtuza

[Former Member]

Hi,

While downloading to MS-EXCEL in the field after selecting radio-button for 'Delimited' or 'Fixed Length' select the 'Appropriate' File origin to get the desired data. You need to try out different options from 'File origin' to achieve the same.

I hope this helps,

Regards

Raju Chitale

[former_member222709]

Hi Venkat,

If you can verify that whether the special character is from SAP or excel. This you need to verify by de-bugging in SAP and then by opening the downloaded file in notepad.

Please refer the link below for details:

Link: []

Regards,

Pranav.

[Former Member]

Hi Kartik,

Even I am also facing same issue. I am downloading some data in excel sheet. Data is internally converting in excel only. When i download same data in .txt format then no special character is coming. So i am sure that it is happening because of excel only. xsjs or hana is not creating any issue. We can get proper data in excel also if we change FILE ORIGIN in excel. But that is not a recommended solution. Please share any other solution if you have any.

Thanks,

Dashrath