Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I really really need help on this and andy input would be highly
appreciated: I am doing a research project and recently got a data file. However, this data file is in word format and needs to be transformed into excel for analysis. Each entry of the data file is some basis information about a company and the file is laid out as follows: ABC Company 123 Some Rd., East City, CA 76543, 223-345-4567 A local leader in electronics manufacturing DEF Company 456 Good St., West City, CA 90987, 209-876-7654 Had a new CEO this year and is planning to open an office in LA GHI Company 789 Lucky St., South City, CA 67887, 321-876-0987 Going to close in 3 months ....... Btw, all company names are in bold letters. I believe that there should be a way to work this out with VBA but I am not familiar with it. I would not mind spending some time to learn it but it would really help if somebody could give me some leads, like a template or something. Many many thanks! Robin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
excel 2002 -how can you convert a file to a pdf read only file? | Excel Discussion (Misc queries) | |||
Pasword protected Excel file encrypted, how do I read this file? | Excel Discussion (Misc queries) | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
Excel file won't open because it' a read only file when it is not | Excel Discussion (Misc queries) |