Excel 2002: Can I split PDF text into columns ?

[Mr. Low]

Hello,

I need to do data analysis from PDF documents.

I do not have any problem in copying entire file and paste it to Excel.

However I am unable to split them into columns.

Is there anyway for me to import or convert PDF data into Excel format ?

Thanks

Low

 

[Pete_UK]

Is all the data pasted into one column in Excel? If so, you can use
Data | Text-to-columns to split it up, maybe using <space> as a
delimiter.

Hope this helps.

Pete

 

[Edward]

Try copy with formatting function in PDF before you patse to excel

Is all the data pasted into one column in Excel? If so, you can use
Data | Text-to-columns to split it up, maybe using <space> as a
delimiter.

Hope this helps.

Pete







- Åã¥Ü³Q¤Þ¥Î¤å¦r -

tr

 

[Mr. Low]

Helklo Edward,

I am using only an Acrobat Reader to open the file. May I know how to copy
with formating ? I only could Select All > Copy to Clipboard and Paste to
Excel is that the correct steps ?

Please guide.

Thanks

Low

 

[Mr. Low]

Hello Pete,

Yes, the text is on one column, but when I use Data > Text to Column tool, I
could not split it into columns. All the text are very close together, there
is no spacing in between them, thus I am not able to use "Space" to split
them.

Any more idea ?

Thanks

Low

 

[David Biddulph]

You can split by any other character which is used as a delimiter, or split
into fixed width fields. If neither of those, how are you deciding which
characters are intended to be in which field?