Pasting list of text and numbers from MS Word

[hongkongphooey]

Hi guys,

I've searched quite a bit for an answer before asking, but here goes...

I have a very large list of top scorers for a sports team MS Word. The name and number of goals are both on the same line.

Is there any possible way I can past them into Excel, so as they are pasted into 2 separate columns?

If I have not provided enough info, please say so.

Thanks in advance.

[shg]

You'd need to separate them with Data > Text to columns or a formula, depending on the format.

[hongkongphooey]

You'd need to separate them with Data > Text to columns or a formula, depending on the format.

Excellent.

I'm only an occasional Excel user, so I was not aware of those functions.

Much appreciated.