MS Word export to EXCEL

[MBct]

I have an MSWord document that needs to be exported to excel. The document is "General Notes". Each note needs to be in its own cell. However I would like any sub-sectioned notes say "upper case A-Z" of note 22. to fall in the same cell as note 22 (invisioning using {alt}+{enter} to accomplish this).
I do not have any experience programming so before I go down that route was hoping for a simple (HA) oh just add this character and export to plain text/ import as comma delimited and there ya go. In all seriousness any help is appreciated. I can get everything I need with a simple copy and paste, but the sub-sectioned text in the same cell is alluding me. Again, thanks for any input.

 

[SkipVought]

Hi,

Please post a representative example of several groups of text, as they would appear in the document, and how you expect each to 1) be identified as a group and 2) be referenced.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MBct]

Here are the two documents.
As for identification, notes 1,3 &4 could be considered "paragraph" notes and note 2 could be considered "sub-sectioned" notes.
How will they be referenced? Well because I am a CAD user I will suppose that reference means a similar function as in most CAD programs... adjust one doc and doc 2 will show adjustments after some sort of re-loading of doc 1?? They will reside in the same network folder preferably with the same name only extensions being the difference.

The real purpose of this is to allow notes (sometimes as many as 100 or more paragraph/sub-sectioned) notes to be placed in a CAD program.

Hard returns in these notes are evil, the CAD group prefers for the notes to be wrapped with no hard returns in a particular paragraph note.

The new CAD program that many companies are moving towards has a pitiful word processor, really no word processor at all for formatting. If you format the text and zoom in and attempt to edit the text will re-format itself. Maddening!

So there is a constituent that started using the programs scheduler (which is very similar to excel) to place notes. I have a macro/script that will pull cell information from excel and place it in the scheduler in our CAD program. I just cant get the (as stated in the OP) word-to-excel to accept {alt}+{enter}.

 

[MBct]

Doc two...

 

[SkipVought]

Some of us have company restrictions on accessing certain data from the web, so your referenced file is of no value to me.

because I am a CAD user I will suppose that reference means a similar function as in most CAD programs... adjust one doc and doc 2 will show adjustments after some sort of re-loading of doc 1[red]??[/red]

[red]??[/red] WHAT?

Please CLEARLY explain what reference means to YOU;

"...show adjustments... " Exactly What adjustments?

not "some sort of" something -- EXACTLY WHAT?



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MBct]

As I explained I work with CAD programs. References in a CAD program is a file that one uses to show information in another file. You have drawing 2 and want to see part of drawing 1 so you reference it or link it might be a better term. If you make any changes in drawing 1 you can open 2 and the changes will show up.
I am not sure what you meant by reference in regards to your statement but I gave it my best shot =)

 

[SkipVought]

Not enough information posted here.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MBct]

You asked "and how you expect each to...be referenced." What does reference mean to you in this regard? I may be able to provide that information that I am clearly not providing.

thanks

 

[SkipVought]

Just pretend that I know absolutely nothing about what you are attempting.

Describe what you are attempting to do, in excruciating detail, including relevant examples.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MBct]

I have a word document (example in post 4) that has been formatted and typed by a coworker. I would like to export the word document to excel. In trying to do so I have saved the word document as plain text (*.txt) and a comma delimited file at same time.
To create the comma delimited file, I follow some instructions:
I first turn on paragraph marks and through a series of find and replace commands, I create a file that is easily saved as plain text and also a comma delimited file. That file is able to be opened into excel. When I open the file in excel all "paragraph" notes fall into vertical cells a1, a2, a3, a4...etc (see excel file post 3)
The problem is the "sub-sectioned" notes. After creating the comma delimited file, and subsequently opened into excel... fall in the same horizontal cells and in alphabetical order a2, b2, c2, d2, e2 f2....
I would like the "sub-sectioned" note to fall in the same cell and the text to fall under the previous line eg a2 (see excel file post 3) instead of a2, b2, c2....
So I am 90% there, I just need to figure out, or have some one step me through the process to get the "sub-sectioned" notes to fall in the same cell, and line-feed-ed or would it be line-fed?

 

[SkipVought]

So let me repeat what I think I understand.

You have data in Word like this...
[tt]
Ref1
Ref2
Ref2, Refx, Refy, Refz
Ref3
[/tt]
and when you import into Excel it looks something like this...
[tt]
Ref1
Ref2
Ref2 | Refx | Refy | Refz
Ref3
[/tt]
where Ref2, Refx, Refy, Refz are in separate cells but you really want them all in one cell?
[tt]
Ref1
Ref2
Ref2, Refx, Refy, Refz |
Ref3
[/tt]
If that's the case, and in reality in ANY case where you want text data in a workbook, DO NOT OPEN THE TEXT FILE DIRECTLY with Excel! Rather, IMPORT the text file, where you can control the parsing and assignment of column data type to your data. When you IMPORT the text file, use FIXED WIDTH, and your data will fall into the destination column of choice.

Then SORT, if necessary, to bring the order that you want.




Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlhelp]

There isn't any easy way of doing what you wish to do.

However, there are some tricky workarounds that have desired effects. In Microsoft Word, first, replace your double paragraph marks to charcters that can be easily identified. That would be through Edit, Replace. Under find you would put in ^p^p and under replace with you would use something like &&&&.

Now using the same technique, replace singe para marks with, say, $$$$. Find: ^p Replace with: $$$$

Now put in your double paragraph marks back into the Word document. Find: &&&& - Replace with: ^p^P

Now copy and paste your document into Excel as Text. Use Edit replace to remove $$$$. Using Find: $$$$ and replace with (ALT+ENTER). To do that in the replace with box, hold the ALT Key and on the numeric Key Pad only, type 0010 and then perform Replace All command.

I tried it on your doc. Works well.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
I should live a long time - I eat a lot of preservatives.