# Regarding Splitting of text and write in excel

#1

I have this txt file and want to write it in excel .
I m unable to split the text file into rows and columns.
i m totally stuck in this.sample.zip (515 Bytes)

#2

@Abhishek14

Create a table with desired column format

Read the text file, replace all double Spaces with single spaces until you find double spaces.

First split the text with Newline

For each found line split with space and the array which you get will be input for Add Data Row to the table Property ArrayRow.

Thanks,