I have a very large TXT file (~3+ Gigs) that I need someone to be able to open up and extract each line into excel.
Each line is about 1281 characters. After each line is in Excel, I need to split up each line into separate columns based on a set number of characters.
For instance, let's say the first line is in Cell A1. I need characters 1 - 5 to go into Cell B1, characters 6-13 need to go into cell C1, characters 14-21 to go into column D1. I've listed the entire character instructions at the bottom of this description.
Here is the file that I need you to extract and format: [url removed, login to view]
I will need you to send me 2 files: The excel file with each line in one column, and the final excel file with multiple columns.
If you are interested, 1) send me a sample to show that you can do it 2)And tell me how long it will take you to do.
Here is the order of the characters: (first line in column 1, second line (6-13) in column two and so on...):
31 freelancers are bidding on average $117 for this job
I tried to open the file and it was temp. disabled due to high traffic. I have been an administrative assistant for 15 years. I know excel up to expert. I am sure I can create the spreadsheet you need. Donna