Copy and Past from PDF formating

[Scotty476]

Hello All,

I have a pdf document that has a bunch of data on it and I am try to figure out the best way to paste it into an excel worksheet. The problem is when i paste the information it all goes into one cell.

Here is a sample of the data:
ECLIPSYS C+ D 21 0 1.30 0.06 0.30 317 1107 97 9.2 9.2 0.00 0.00 0.00 0.0 20 20.0 6.46 70.6 1.98 -137 39
ECOLAB A- A 44 -2 0.63 1.36 1.36 4 11141 54 19.0 13.4 0.31 0.29 0.40 0.9 13 13.9 6.19 32.6 1.02 20 64
ECOLLEGE.COM C D 18 2 0.94 0.28 0.25 444 394 82 5.4 5.4 0.21 0.00 0.00 0.0 18 18.0 3.79 70.8 2.70 155 52
ECOLOGY/ENVIRON C+ C 10 0 0.51 0.68 0.55 67 42 17 5.9 2.0 0.01 0.65 0.36 3.5 11 14.5 1.10 18.6 0.85 -195 73
ECTEL LTD C D 5F -5 1.19 0.00 0.10 999 88 2 3.0 3.0 0.00 0.00 0.00 0.0 14 14.0 1.44 48.5 2.76 -457 12

Does anyone have any tricks that i could use to seperate out this data into individual cells for sorting. Maybe there is a way to tell excel to start a new cell whenever there is space.

Thanks for your help.

Scotty

[Carim]

Hi Scotty,

Have you tried Data Text to Columns ...?

HTH
Carim

[Scotty476]

OK i figured out how to split it into spaces by cells but then it takes the company names with spaces in them and splits them out so the colums dont align. Any ideas to get around that?

thanks

[Carim]

Hi again,

The shortest answer is to use

Please Login or Register  to view this content.

HTH
Carim