You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Help, I have found several that will do what I need, but they only convert the first 2 pages and then demand £10 a month. Any solution?
Several pages of lists with coloured formatted boxes to convert.
Many thanks if you can help.
Wally
Can't you just copy the table, paste it into a text document, organise it as CSV then import it into Excel and add the formatting?
That's what I'd probably do.
have you tried Zamzar.com? Free so worth a shot.
Suggest trying the following
Can you select the data, if so use paste and text to columns in excel
Try running ocr if you can't select anything
Export the to a web page on your desktop, open in word, select the data and paste in to excel, then use text to columns
You could of course just key it all in..... Or ask the originator for a copy in excel?
Thanks for suggestions, found one limited to two files an hour that works perfectly.
found one limited to two files an hour that works perfectly.
Link?
I occasionally have to do this and have to piss about with the CSV and import faff.
I have a full version of acrobat which will save a pdf in excel format. How many spreadsheets are we talking? I could have a quick go if it's just one or 2. DanJDOTHeywoodATgmailDOTcom
I have a full version of acrobat which will save a pdf in excel format.
mugsys - Thanks for that! I have Foxit PhantomPDF and have just found out it can save as Excel as well. Didn't know it could do that! 😳 Save's me a bit of faff now.
Bit bespoke
But for things like results lists, where your converter, is having trouble with the columns
This formula will find/use the "space" between the columns to dice the data up
=IFERROR(RIGHT(C5,LEN(C5)-FIND("$",SUBSTITUTE(C5," ","$",LEN(C5)-LEN(SUBSTITUTE(C5," ",""))))),C5)
This formula will find/use the "space" between the columns to dice the data up
Yeeesh - just use the Text Import Wizard (under [i]Data->Get External Data->From Text[/i] in my version of Excel 2010)
You can tell it what delimits your text into columns (space in your case) and to combine multiple delimiters into one (to handle multiple spaces).
Anything more complex than that I'd probably just bash together a quick awk script to pre-process it.