Hi guys, I have a text file with thousands of data. I wanted to copy the data into excel file and split the data into multiple column (dynamic) depends on the delimiter which is comma (,) without using hotkeys.
I managed to do the read text file and paste it inside excel for every row in one column only. Now I’m stuck with split that column A into multiple column by using delimiter comma(,) and the columns should not be fixed since it depends on the data after the splitting.