prob with excel

P

parul

Member
i am using the 9.1d version.
during a report generation, some comments are generated which i copy to excel. now, if i use enter i.e chr(13) as delimiter each comments goes to diffrent row. i want that each comment should start with a new line in same row.Alt + Enter is used as hard carriage return. so i tried to use chr(1038) as delimiter between two comments, still when i copy the comments to excel they do not come in same row diffrent line, they come in same row same line.
please guide me as to which keycode should i insert between the comments , such that when i copy them to excel they come in same row but new line.
i will be grateful for ur time and help.
 
Try putting quote characters arround your comments eg:

Code: 
Field# 1,"
This is comment line 2",Field #3
Field# 1,"This comment is on one line",Field #3

If you save this text as a .csv fine and open in Excel it looks like you describe. You may will need to adjust the height of the line where your multi line comment is.
 
thanks for the reply.
yes, i am trying to have a workaround. I am also thinking about inserting the chr(9).
Anyway, if you get the key value of hard carriage return in excel)ALT + ENTER) , plz let me know.
thanks again.
 
You must log in or register to reply here.
Back
Top