Excel data stripping
 

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.

Excel data stripping
 

Hi,

You can make a table in excel itself and then copy the entire data into word
file. This site can also help you.
http://office.microsoft.com/en-us/he...994461033.aspx
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"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.

Excel data stripping
 

I appolise, I didnt explain myself correctly. All the data comes to me in
one column, and reather than seperate all the lines is there a quicker way, I
am also running Office 2003.

"Suleman Peerzade" wrote:

Hi,

You can make a table in excel itself and then copy the entire data into word
file. This site can also help you.
http://office.microsoft.com/en-us/he...994461033.aspx
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"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.

Excel data stripping
 

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.

Excel data stripping
 

And again as BT says, look to Word for some tricks

Work will do a Mail Merge which is well worth learning.

However there are lots of unique ways of doing this which all depend on how
you set up the Excel file and save it, and which versions of Word and XL you
have.

The advantage is you can get a nice neat logical result in Word.

Try it out, and if you get stuck come back for help here.

Cheers Will

"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.

Excel data stripping
 

The site address had the solution in word and not in excel and as rightly
said by willy you can try to work with mail merge.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"BT" wrote:

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.