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

--
A36B58K641


"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