Troubleshooting: copy numbers from *.pdf to *.xls

[Gizmo]

Hi guys,

I'm dealing with a matrix of numbers in *.pdf format and would like to copy
only some specific lines from the table.

I tried to copy the data (numbers) from pdf to excel using "Text select
tool" or "Column select tool", but in both cases all numbers are put in one
cell, so that I get in A1 a long stream of data like:
3.85 4.38 4.25 4.42 4.67 4.77 5.03 4.70 4.37 4.53 4.11 3.39.



I wonder if there is there any possibility to "paste special" or
"anti-concatenate" this somehow in order to get the data separated
one-per-cell rather all the bunch together ?

Somebody of you had already a similar problem?



Thanks a lot for your help on this!



Gizmo



P.S. In case it seems to be too abstract, the data I try to copy to excel
(only US and Euro-area lines) is under:

http://research.stlouisfed.org/publications/iet/20020201/iet.pdf , pp.3 to
4.

 

[Patti]

Have you tried Data -- Text-to-Columns -- Delimited,
choosing "Space" as the delimiter?

 

[Gizmo]

Thanks Patti for your hint, it works!
There are still some minor troubles (line names under the data), but it's
nothing compared to what I was confronted with before...
Thanks once again,

Gizmo