I need a help to convert the text file to excel.
In the below Image You can see “Master Account Code” and “Agent Name” and so on …this are the Headers of the excel.
Now we need to extract the data from note pad file Starting with 4 spaces " B657A00"
Is there any logic to get this kind of information .
I have tried in this way
Help me if there is any solution .