How can i paste the text as tesse in excel sheet with matain the line to line gaps

how can i paste the text as tesse in excel sheet with matain the line to line gaps

@Surya_Prakash_Akula

You can read the data using Get text…then use generate datatable and send the data in and get a datatable…you have to play around line and column separators…you can then paste the datatable to excel

cheers

hello,

do you want to write all that text in one excel cell ?
if so you can split by “\n” and add vbNewLine instead

regards

yes i want to write all the text in on excel cell