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"
Can you please help to get the below logic how it works…
1)I have summary file(text File) which contains some partners data .(File1)
2)I have few failed partners data in excel.(File2)
Objective:Based on failed partners data,i need to keep that data in Summary file(File1) and remove the remaining partners data. (7.8 KB)File1.xlsx (7.8 KB)