Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm novice level with Word and Excel, so excuse what may be a basic
question/problem that I've got. I asked an employee to enter lots of data into Excel. The data is company name, address, contact name, and phone number. I requested that each type of data be entered into different columns. Instead, the employee used MS Word 2003. To compound the issue, the employee did not use commas, tabs, or any other delimiter or formatting method that might allow me easily to get the data over into Excel (by *easily* I mean using a technique that I know ; ) The data in Word simply is separated by random numbers of spaces. Nothing lines up, either, so I can't use the manual column markers in Excel's Open As wizard. What are my options for getting the data into Excel with the 4 categories in separate columns? There are several hundred rows of data. Thank you, JM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Transferring Excel Data to Word Document | Excel Discussion (Misc queries) | |||
exporting excel worksheet to word | Links and Linking in Excel | |||
combined cell data from Excel to Word (2003) | Excel Discussion (Misc queries) | |||
Word field codes in Excel data file Includetext | Excel Discussion (Misc queries) |