Currently, my data are in .rtf format in Word and when I copy into Excel
2000, it puts all the data into one column in different rows.

Is there any possible way when copying from .rtf format from MS Word 2000
into Excel, it can be in different cells in Excel as you would normal copy
and paste data from Word to Excel and then you can do the text to column
functionality?