Skip to Content
author's profile photo Former Member
Former Member

Special Character Problem In MS Excel

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Dec 15, 2011 at 02:52 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2011 at 05:26 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 17, 2011 at 07:24 AM

    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: [fm-guidownload-not-picking-initial-zero]

    Regards,

    Pranav.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2015 at 11:04 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.