Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formating of text file
i have problem while formating a text file into excel containing the below
matter i want the "Bank reference", "Amount", "Information", "Customer details " and "bank clearing ID" in first row and the corresponding information below the corresponding headings. i have tried the use the custom in the filters and take the details into a next tab. everything is working, however only one line from the "information" and "customer details" is picking. Second line and the line after one blank line is also not picking. it would be great if some body could find the solution as to how i can take the full information from "information" and "customer details" . Bank reference 99912000 Amount 123.54 Information bjasdbvlaksdjbvfsdbvsdfvnbnjnvjksdf 70000151651 bvasdbh 70054685485wfasdf awehieuavfhwe 7000045454 Customer details bnjksdnvsldjkavn 1545 adbnajkfbvad 1588 asvsdvsdv bbslvjhbsd 5555 bank clearing ID 4545454545862121 Bank reference 99912000 Amount 123.54 Information bjasdbvlaksdjbvfsdbvsdfvnbnjnvjksdf 70000151651 bvasdbh 70054685485wfasdf awehieuavfhwe 7000045454 Customer details bnjksdnvsldjkavn 1545 adbnajkfbvad 1588 asvsdvsdv bbslvjhbsd 5555 bank clearing ID 4545454545862121 rgds, rkp |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formating of text file
On Apr 30, 3:08*pm, Radhakant Panigrahi wrote:
i have problem while formating a text file into excel containing the below matter i want the "Bank reference", "Amount", "Information", "Customer details " and "bank clearing ID" in first row and the corresponding information below the corresponding headings. i have tried the use the custom in the filters and take the details into a next tab. everything is working, however only one line from the "information" and "customer details" is picking. Second line and the line after one blank line is also not picking. it would be great if some body could find the solution as to how i can take the full information from "information" and "customer details" . Bank reference *99912000 Amount * 123.54 Information * bjasdbvlaksdjbvfsdbvsdfvnbnjnvjksdf 70000151651 bvasdbh 70054685485wfasdf awehieuavfhwe 7000045454 Customer details bnjksdnvsldjkavn 1545 adbnajkfbvad 1588 asvsdvsdv bbslvjhbsd 5555 bank clearing ID * * * * * * 4545454545862121 Bank reference *99912000 Amount * 123.54 Information * bjasdbvlaksdjbvfsdbvsdfvnbnjnvjksdf 70000151651 bvasdbh 70054685485wfasdf awehieuavfhwe 7000045454 Customer details bnjksdnvsldjkavn 1545 adbnajkfbvad 1588 asvsdvsdv bbslvjhbsd 5555 bank clearing ID * * * * * * 4545454545862121 rgds, rkp Not sure what you mean by "picking" read the file into Excel data is all in column A perform texttocolumn, delimited by space pull data to relevant positions alternatively, read the file in sequentially look for keywords for action; keywords are your column headings. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a file that is 4mb. Cleared all formating...still big | Excel Worksheet Functions | |||
How can I apply conditional formating for cells in different file. | Excel Discussion (Misc queries) | |||
Adding Dashes in front of text using text formating | Excel Discussion (Misc queries) | |||
Opening and formating a CSV file? | Excel Discussion (Misc queries) | |||
req assist with import and formating a text file | New Users to Excel |