Seperate Data from one column to several columns

[BigHat]

I'd like to copy information from a PDF into a worksheet. The information looks like this:

1 PAOZZ 5310-00-918-0482 80205 NAS1291-7 NUT.............................................................................. 1
2 PAOZZ 5305-00-995-2125 80205 NAS603-7P SCREW.......................................................................... 2
3 PAOZZ 5305-00-866-0937 80205 NAS603-8P SCREW.......................................................................... 14
4 PAOZZ 5306-01-106-8238 80205 NAS6603-3 BOLT ............................................................................ 8

When I paste it into excel it all gets entered into one column, I'd like to spread it out over 7 columns. Is there an efficient way to do that?

[popipipo]

Use the excel tool 'Text to Columns'

[BigHat]

Ah, yes, that works nicely!

Thanks!