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

Help Studio
, ,
1

image
image1366×768 116 KB

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

2

@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

3

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