Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting text files to Excel - a difficult one
Hi friends
We have a situation where an elementary planning technique software outputting all its strategic plans in to a word document. I am trying to conver this in to an excel file in order to design a database. The output looks like this( I am giving only thee samples 1.1, 1.2 & 1.3 but the list consisits of 10 -15 plans). 1.1 Staff Training Plan -- Priority: A The Purpose of this plan is: To have an operations team that has the appropriate skills and abilities to perform effectively The Strategy for achieving this will be: 1) Prepare a brief report describing the specific skills and knowledge required to operate the warehouse effectively. Timeframe - by 15.07.04 2) Survey & briefly document the current level of relevent skills each member of our team has Timeframe - by 10.08.04 3) Prepare a schedule of training sessions necessary to fill the skill gap Timeframe - by 30.08.04 The Person or Position Responsible & Accountable for delivering the above is: 1), 2) by DW 3) RD ---------------------------------------------------------- 1.2 Inventory Training Plan -- Priority: C The Purpose of this plan is: To put in place systems to ensure we have the right adequate stock level to meet most demand situations without carrying uneconomical inventory levels. The Strategy for achieving this will be: 1) Prepare the appropriate RFP for a computer system to meet this requirement Timeframe - RFP received by end of October 2) Request a management decision Timeframe - by end of 2004 ----------------------------------------------------------- 1.3 Fast Turnaround Dispatch Plan -- Priority: B RH The Purpose of this plan is: To be in a position to provide delivery within 24 hours for a 90% of orders received The Strategy for achieving this will be: 1) Prepare a brief procedure manual covering each step of the order-filling process Timeframe - by 15.10.04 The Person or Position Responsible & Accountable for delivering the above is: RH ----------------------------------------------------------- I am planning to have excel headers Plan No - 1.2, 1.2 1.3 etc Plan Name: Purpose Strategy Timeframe Priority Person Responsible My problem is that I do not know the code to seperate out text strings what I plan to have headers (plan Name), Priority, purpose etc in to excel columns and list each description under them in each row. Can Somebody please tell me a code for this or point me to an article which will help me to do this. Thanks Sarah W |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel (xls) files spontaneously converting to text files | Excel Discussion (Misc queries) | |||
Converting Large XML Files into CSV Files for Excel | Excel Discussion (Misc queries) | |||
Converting Adobe files into Excel files | Excel Discussion (Misc queries) | |||
Difficult to open files in Excel in different countries | Excel Discussion (Misc queries) | |||
Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) |