*
I have this email attachment from my slate supplier which opens in Acrobat but I can’t seem to convert it to Excel, in order to manipulate the inventory numbers. Can anyone here help?
Thanks
Terry
*
I have this email attachment from my slate supplier which opens in Acrobat but I can’t seem to convert it to Excel, in order to manipulate the inventory numbers. Can anyone here help?
Thanks
Terry
Listeners write in about saving frogs, attic ductwork, lime wash, and energy ratings for real estate.
"I have learned so much thanks to the searchable articles on the FHB website. I can confidently say that I expect to be a life-long subscriber." - M.K.
Get home building tips, offers, and expert advice in your inbox
Fine Homebuilding
Get home building tips, offers, and expert advice in your inbox
© 2024 Active Interest Media. All rights reserved.
Fine Homebuilding receives a commission for items purchased through links on this site, including Amazon Associates and other affiliate advertising programs.
Get home building tips, offers, and expert advice in your inbox
Become a member and get instant access to thousands of videos, how-tos, tool reviews, and design features.
Start Your Free TrialStart your subscription today and save up to 70%
SubscribeGet complete site access to expert advice, how-to videos, Code Check, and more, plus the print magazine.
Already a member? Log in
Replies
*
Here it is. Thanks for the help.
*You can't really convert the data. The closes that you can do copy and paste the data in Excel.Under Tools, Select Text. Then mark all of the data in the columns that you want.What you will end up with is a a row of data for each line with a space between each item.I don't have Excel so I am not sure what how it handles the data. You might have to paste it in a file and save the file and then use Import.The dittos might also cause a problem.
*Hey Terry, Probably no help here, but...I tried opening your link with with aol browser, no luck. I went to Netscape, and opened it with Acrobat Reader 4.0, copied, and pasted it into an Excel Spreadsheet. No problem, but then, I've got a Mac, ya gotta get the right tool for the job...Holly
*When you copied to Excel did anything work as Terry wanted it to? There were no formulas or cell information to transfer.
*So email it to him already, Bucksnort. Gee wiz. b : )
*When I do a copy and paste, I have to do it one cell at a time, otherwise each line copies into one cell. Sorry to be a pain but is there an easier way, am I missing something?ThanksTerry
*Terry, ask if they will send you the Excel files.
*KaiI would but they're working on Mac's.The funny thing is, I think I could convert a Mac file, any ideas?I'll give my supplier advice if you guys can give it to me, It'll save me having to re-enter 24 pages of similar inventory. Not to mention future jobs.Thanks
*Terry, I think Mac's are smart enough to Save As a format a PC can read. It's worth a try. That cut/paste stuff is the pits, and as someone pointed out (sorry, can't recall who right now), you lose the formulas.
*TerryI tried what I suggested in copy and pasting it into a another program, saving it to file and them importing into the spreadsheet and IMPORTING into the spreadsheet using the option to use use spaces for separators. That "sorta" worked, but there where problems such as the Unfading Green and the following dimensions was treate as 3 different cells. So you would have to do some edit any way.If they can't save in an PC Excel format (or there is not an option in the PC version of open a Mac EXcel file) ask them to save the file as a COMMA SEPARATE FILE (CSV) and have them email that to you. It will not have the formulas, but have all of the cell information.
*If you copy and paste the stuff in excel, try to "parse" the data. In the version I have (exccel 2000) you click on "data" and select "text to columns". That sorts out the stuff into individual cells. If you don't have that version, type "parse" into the help assistant thing and see what it comes up with. The suggestion Bill Hartmann made should also work - The "comma delimited file". (If they're willing to send it to you that way)
*Log onto http://www.computertalkwithtab.com and ask your question there in the Forum, under Listener Questions and Answers.It's a fantastic sight for computer/hardware/software related questions from novices to experts alike! Lots of great advice and answers.
*Hi Terry, pleased to meet you.Few people realize that MS Office always comes out first on Macs. Always has. Excel files are identical, and platform independent. It's just that the Mac versions have more features and a cleaner interface. AppleWorks is a very popular cross platform alternative to Office and also writes/reads Word, Excel, etc. files. So if they use it, you can get a readable file from them.The other weird thing is that the Mac OSX Aqua interface is Adobe PDF native. So if they are up to speed, they should be able to send you something you can use directly. H
*Well you can do it but the effort is probably more time than to recreate it from scratch.You might try copying and pasting the acrobat into Word first and then you can manuver the info in word before pasting to excel. In Excel you can use the text to columns in the DATA drop down and select the criteria for converting. It takes practice and for the size of the stuff you are working on I think a worksheet from scratch is not too much effort. Should be able to do it in a half hour ar so.
*Thanks for all the help everyone. I've forwarded some of your suggestions to my supplier and he's trying them for me. For years I've re entered all of these sheets and it's not that difficult, I just think we should all take full advantage of our tools to make our work easier.Thanks againTerry
*Terry,Find out what version they are using and tell them what version you are using and you should be able to work it out.The Mac version of excel can save to any number of PC compatible versions of excel. You should also be able to take a raw mac excel file and open in excel for the PC, as long as the mac file is not a newer version of excel than the one you are using.I'm sure you can get it so you can exchange files seamlessly. My wife is going to business school and must open and edit excel files on her mac and share them with PC users. As far as I know she doesn't even have to do any special saving routine. The files will just go back and forth with no added translation.Steve
*If they have it in Excel for Mac, they should be able to save it to a format compatible with whatever version of Excel you have for PC, e.g. Excel 97 format. Just make sure they include the ".xls" on the end of the file name, otherwise the PC won't know what to do with it. Other than that, the PC and Mac versions of Office are completely cross-platform compatible.
*Hope nobody minds my delurking for this...i When I do a copy and paste, I have to do it one cell at a time, otherwise each line copies into one cell.Try selecting Paste Special, then choosing Unicode Text from the options. I couldn't copy from the page with my PC, but I do a lot of importing from text filesat work, and this works for me.
*John,Welcome to posting! Delurkers are always welcome (unless he or she is a troll apparently!).Rich Beckman
*PDF = Portable Document Format, a way of "printing" a document so that it can be easily shared without having whatever software was used to create it. Anyone can VIEW the document, but not MODIFY it, so no formulas, no layout, no nothing.So go with Helen, Steve, Andy etc. - get the original .xls file and your are good to go, PC or Mac. My computer/network roots are showing...
*
I have this email attachment from my slate supplier which opens in Acrobat but I can't seem to convert it to Excel, in order to manipulate the inventory numbers. Can anyone here help?
Thanks
Terry