Hi Steve
I suspect the solution to your problem is in Word, not Excel. Assuming your
data is consistent (ie for each row you have five fields, whether populated
or not), simply copy into Word and explore the Table / Convert feature.

Good luck!

"Steve Moss" wrote:

I have a problem stripping data from Excel to word. I receive an excel
spread sheet with a list of personnel attending courses. I need to transfer
all this info into a word file and into a table. Is there a quicker way to
do it apart from cutting and pasting each section. the information comes to
me as : where from","Confirmed Enrolment","ID No","Surname, forename
initial","title","job title

the speach marks and commas are included in the text. If this is not
possible is there a way of automatically seperating the data onto another
excel sheet.