on 12-27-2014 8:37 AM
hi every body
I have problem with this issue . when I export the report from sap to excel , some of the cell and columns in excel are distribute .
look at this screenshots :
1-main file
2-after export
I saw the some of material that have this problem . all of these material distributed in excel :
most of them have the symbol . do you know which character is cause that . or has any role for character of the description of master data???
Dear Ali Khojaloo,
the same issue i have faced previous, the main cause is, if the material description starts with quotation mark (") and it is not end with same. it distribute materials until system finds another quotation mark in the description field. Please remove the symbol and try to export again.
Regards,
B V
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear B V yadav
thank you for your posting.I change the material descriptions and add in first or end of that . after that I report and export to excel . but this time the problem was solved .
Regards
ali khojaloo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
First of all follow the instruction given by , If still same problem is persisting
then you can directly copy and paste from SAP to Excel for eg. select the material number to material description, press CTRL+Y & select the detail then press CTRL + C & paste in Excel sheet, hence I could be copied exactly.
Kind Regards
Kamlesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Download it as local file in txt format.
Then open Excel and select from Excel menu "Open file" and select your text file.
Excel directly open then the import assistant where you can define yourself how you want to separate the fields
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Khojaloo,
Instead of Local file kindly use downloading through Spreadsheet.
Regards,
Karna J
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.