How to download texts into excel with line breaks (in same cell) URGENT
I am downloading data in to excel but the data is coming in single cell and in continuation.
I need to put line breaks in the cell so that each line is displayed seperately in the cell.
I tried using :
DATA: line_br(4) TYPE c VALUE '0Aew'.
CONCATENATE wa_out2-text i_text-tdline space INTO
wa_out2-text SEPARATED BY line_br.
also I used line_br = '0D0A'.
but of no use.
I tried using CL_ABAP_CHAR_UTILITIES==>NEWLINE etc but it also didn't helped.
Can some one please let me know how to do it!