Word2Excel Import Problem

[sayberman]

Hello everyone,
I want to import a word file content into XL in a controlled manner instead of a copy-paste method. Word text is basically made up of item numbers followed by its multiple line definitions.

If I only copy-paste the entire text into XL, text spreads over couple of columns and item numbers go into same column with the definitions. What I want to do is to import the "item numbers" into column-A and the "item definitions" to column-B (all its lines into one cell)
in Excel.

Any help for VBA code string is highly appreciated.

Cheers,

 

[Cindy Ellis]

If the item numbers are separated from the rest of the information by a specific character, or are always a specific number of characters, you can use "text to columns" to split data appropriately into columns.
If that doesn't work well for you though, answers to the following questions (and maybe others as we work toward a solution) should help us help you:

• When you look at the data in Word, how do you know what info is an item number and what info is a definition?
• When you do a straight "paste" from Word, does information intended for a single row end up divided into 2 or more rows?

If you could post a bit of the data (nothing confidential obviously) it will really help.

Cindy

 

[sayberman]

Hello Cindy,
Answers to your questions:
When you look at the data in Word, how do you know what info is an item number and what info is a definition?
There are the item breakdown numbering in the begining of each item. (See following example)

When you do a straight "paste" from Word, does information intended for a single row end up divided into 2 or more rows?
Answer: If the item description is long and detailed and has multiple rows in word, paste operation ends up with divided rows. (then I need to manually concatenate). If it has a single row, information is intended for a single row.

I hope I am clear. Thank you.


PARTIAL SAMPLE TEXT FROM THE WORD FILE

3000 ELECTRICAL SYSTEMS
3001 Electrical systems, General
3001.1. Unless otherwise specified, all eletrical systems shall comply selected with Class authority design and validation rules. In case the Class society design rules or international standards are not directly applicable, or Class society has no available rules for design items, applicable rule and/or international Standard will be identified by the contractor. Contractor will be liable to present rules to approve the bidding authorithy representatives.
3001.2. Should the sections of standards and/or the applicable rules for voltage characteristic are different than contract specification voltage characteristics, those sections will be omitted in the standard.

3001.3. Not applicable.

3001.4. All the utility power sockets and receptacles will be according to customer application standards.

3001.4.1 Not applicable
3001.4.2 As specified in item 3022.1 in section 3022