I have to deal with unformatted text files which contains transactions. I am attaching here sample of this text file in Sheet1 which contains many data which I don’t need. I have manually arranged data of this unformatted text file data in the manner I need in Sheet2. Kindly provide the solution to arrange this data.
Try to paste the data from unformatted text to wordpad. From Wordpad copy and paste it worksheet and upload that file.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
new excel file attached which contains data pasted from wordpad file
Last edited by KRIXXXX; 01-15-2022 at 12:12 AM.
Code for macro
This code is tailored with guess and approximation for given data. Pl check thoroughly with other data before using.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks