Excel data stripping

S

Steve Moss

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

Steve Moss

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

BT

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!
 
W

willy

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
 
S

Suleman Peerzade

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top