Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stripping Information | Excel Discussion (Misc queries) | |||
Stripping The First Four Characters from a value | Excel Discussion (Misc queries) | |||
Stop Excel from stripping out leading zeros when saving as CSV | Excel Discussion (Misc queries) | |||
Stripping the dashes | Excel Discussion (Misc queries) | |||
Stripping and Conversion. | New Users to Excel |