Posted: 4/30/2017 9:07:17 AM EDT
|
I have a lot of news files that i have saved from ar15.com and converted them to text. I was wondering if there is a easier way to bring them into Excel
Right now I have to copy the title to Cell A and then right click insert comment then add the text into that and doing that 500+ times is going to suck just wondering if there is a easier way then what I am doing now. |
|
Quoted:
That's abuse, but I can't decide whether the software or the user is getting the worst end of the deal. Save the files in a text editor or Word, with a simple copy paste operation. A better option might be Access. |
|
I am trying to short all the shit on my computer and cut down on files and folders every were. I also run into problems when copying a lot of small files
If there is a better way to do this in access let me know I have never used it but it looks like this Title of the text file ***FBI and Grand Jury grilling 20 NYPD over bibery of cash and travel*** Then the news (I remove all the bull shit so its just the article makes it easy to read) A grand jury also has been convened, sources said. The investigation began with an unrelated deal-gone-awry involving the two businessmen — Mayor de Blasio buddies Jona Rechnitz and Jeremy Reichberg, well-placed sources said. They gave a large sum of money to a third party who was supposed to buy discounted liquor for them to sell at a profit, but investors lost their money and the feds opened a fraud probe, sources said. Wiretaps on the two businessmen’s phones revealed relationships with several NYPD cops — and the probe soon led the feds to then-NYPD Chief of Department Philip Banks and his close pal, Corrections union president Norman Seabrook, sources said. Reichberg, who lives in Borough Park, is a police buff known for his NYPD connections, while Rechnitz is a deep-pocketed de Blasio donor from the Upper West Side, sources said. The businessmen became close friends with Banks and Seabrook, with the foursome traveling together to the Caribbean and to Israel in 2014. Rechnitz picked up both men’s tab for the Caribbean jaunt, sources said. He also paid Seabrook’s airfare and hotel bills in Israel, while Banks paid for the flight but allowed Rechnitz to pick up his lodging tab, sources said. Although he was on his personal time, Banks wore his NYPD uniform during a visit to the Western Wall in Jerusalem, and when he returned to New York, shared what he had learned with authorities here, sources said. As a thank-you gift for all Rechnitz had done, Banks and Seabrook bought him a pricey backgammon set made of ancient wood. “[We] spent $5,000 on the backgammon set — custom-made from Israel — so that nobody could say they bought me the [plane] ticket,’’ Seabrook told The Post Monday |
|
Quoted:
The best justification for Excelhere might be a mass table format - Word gets wonky with a huge pile of tables. A better option might be Access. Quoted:
Quoted:
That's abuse, but I can't decide whether the software or the user is getting the worst end of the deal. Save the files in a text editor or Word, with a simple copy paste operation. A better option might be Access. Editing to clean out the trash is usually needed. I will bet that a table of annotated links is better choice for this thread author. |
|
I have many articles alot is news some is science and so on and so on. So having 1000 .txt files in just one folder can be searched and i can just open the txt file but I just don't want all of these individual txt files i want just 1 excel file. Its also easier to share with other people when dealing with 1 files rather then 1,000 files
Yes ctrl C and Ctrl V is what I am doing now but its really slow going. But when you do that in excel the text covers many cells which is why i was doing the comments in excel. I am trying to find a faster way but it looks like i might be shit out of luck and just have to work on it little by little |
|
Open Excel.
Depending on what version of Excel you have, you'll have to figure out where the button is, but you want to "Record Macro" Give the macro a name and a shortcut key (something like ctrl+J that you don't use for anything else in Excel). Start recording. Go to file --> open and tell it "all files" Select one of the files and click "open." It'll bring up the Text Import Wizard. You can tell it to use certain characters in the text file to separate cells (such as commas, semicolons, spaces, tabs, or whathaveyou - very useful for making a list of email addresses), or just have a set number of characters per column. Finish to import the file, then do whatever editing you need to do - but only the editing that will be the same for all the files. Then click "Stop Recording." When you click on the macro button, or hit your keyboard shortcut, it'll open up the "open file" dialog and you can click on a file and it'll do all that stuff automatically for you. If you want to get fancy, you can hit alt+F11 to open up the VISUAL BASIC editor and you can google for help to make a dialog box to open ALL the files at once and process them, instead of doing them one at a time. If you're dealing with 500+ files, it may be faster to learn the basics of VISUAL BASIC (and it is pretty easy - I'm not a computer programmer at all!) and write the program than to do them all by hand. Especially if you think you might want to do this again later. |
|
As the_naked_profit stated, your best bet to do what you want in Excel is the macro system.
Though I'd give Access a try first, a database is better suited to hold that amount of data. Its been a while but IIRC Access has import wizards that might do what you want. |
|
Quoted:
I have many articles alot is news some is science and so on and so on. So having 1000 .txt files in just one folder can be searched and i can just open the txt file but I just don't want all of these individual txt files i want just 1 excel file. Its also easier to share with other people when dealing with 1 files rather then 1,000 files Yes ctrl C and Ctrl V is what I am doing now but its really slow going. But when you do that in excel the text covers many cells which is why i was doing the comments in excel. I am trying to find a faster way but it looks like i might be shit out of luck and just have to work on it little by little |
|
Quoted:
I have many articles alot is news some is science and so on and so on. So having 1000 .txt files in just one folder can be searched and i can just open the txt file but I just don't want all of these individual txt files i want just 1 excel file. Its also easier to share with other people when dealing with 1 files rather then 1,000 files Yes ctrl C and Ctrl V is what I am doing now but its really slow going. But when you do that in excel the text covers many cells which is why i was doing the comments in excel. I am trying to find a faster way but it looks like i might be shit out of luck and just have to work on it little by little |