Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to download texts into excel with line breaks (in same cell) URGENT

Hi,

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!

Thanks

Regards

Ab

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question