Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |