How to split text file to multiple columns and get output in excel format

[Sunithaprdp]

I would like to split the text file into multiple columns and the desired output should be in excel format. 

The characters in each column should be as such:

13

13

11

5

16

8

8

15

15

11

11

7

13

11

12

4

2

Can anyone please help me with the same?

I am attaching a sample text file to this query.

Thanks in advance.

[binuacs · Accepted solution]

@Sunithaprdp one way of dong this with the Regex 

[Sunithaprdp]

@binuacs : Thank you so much , it worked!

[Sunithaprdp]

@binuacs what if we have to split multiple text files at a time? Can we use Directory tool ? If so in the REGEX tool should we use Directory as the path?

[binuacs]

@Sunithaprdp you need to combine all the text file then apply the Regex formula if you want to split all the files in same character length.

for combining the text files you can use the directory tool and a batch macro

[Sunithaprdp]

@binuacs yes I could join them but however the output generated is giving me first two columns with a combined data. I would only require only from third column. What should we do in such cases?

[Sunithaprdp]

@binuacs : could solve it, Thanks!

[binuacs]

@Sunithaprdp good to know that you solved it. please let me know if you see any assistance. 

[Sunithaprdp]

@binuacs Sure, Thank you so much.