Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 385
Default PDF - text to columns into Excel

I am trying to convert a PDF into an Excel file. It is not copying over
properly. There is nothing to delimit the data, and text-to-columns based on
fixed width does not work.

What should I do?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9,101
Default PDF - text to columns into Excel

YOu need a converter. If you have Adobe Profession writter it contains a
converter. There are also many commercial converter available (search for
PDF converter on web). Sometimes Pasting the PDF document into Notepad you
can extract some of the information you may need. Also copying portions of
the PDF document sometimes works. I usually try pasting the PDF into word
1srt, and then taking the word results and putting it into Excel..

"Jennifer" wrote:

I am trying to convert a PDF into an Excel file. It is not copying over
properly. There is nothing to delimit the data, and text-to-columns based on
fixed width does not work.

What should I do?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 236
Default PDF - text to columns into Excel

Hi Jennifer,

Another option - if the PDF has lots and lots of numbers in it - is to
scan the PDF at 300 dpi and use OCR (optical character recognition)
software to convert the numbers into a text file.

If you have a Cannon scanner - even their cheapest model comes with
pretty good OCR software.

The result might be as good as what you'd get using Adobe Distiller.
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 143
Default PDF - text to columns into Excel

I am trying to convert a PDF into an Excel file. It is not copying
over properly. There is nothing to delimit the data, and
text-to-columns based on fixed width does not work.


Depending on the document, I can sometimes do this one column at a time.
That's certainly not ideal, but sometimes useful.

To select a column in Adobe Reader 6.0, click on "Select Text" or use
Tools Basic Select Text
and hold down the Alt key while swiping the mouse cursor diagonally over
the column.

Then copy from the Reader and paste into Excel.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel how to add text in columns curley stooge Excel Discussion (Misc queries) 0 January 16th 07 08:24 PM
"Text to Columns" for many columns in Excel 2003 NickName Excel Discussion (Misc queries) 12 September 8th 06 10:14 PM
Excel is automatically doing "text to columns" upon paste text. robert10000 Excel Discussion (Misc queries) 1 June 15th 05 07:49 PM
Linking text columns with text and data columns Edd Excel Worksheet Functions 0 March 17th 05 04:23 PM
add text of 2 columns in Excel A+B=AB Revwd40 Excel Worksheet Functions 10 December 29th 04 07:44 PM


All times are GMT +1. The time now is 06:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"