View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Edward[_3_] Edward[_3_] is offline
external usenet poster
 
Posts: 12
Default Excel 2002: Can I split PDF text into columns ?

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


On 11月11日, 上午12時09分, Pete_UK wrote:
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

On Nov 10, 4:01 pm, Mr. Low wrote:



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


--
A36B58K641- 隱藏被引用文字 -


- 顯示被引用文字 -


tr