Columns of Numbers each in its own frame

[Texas Nuckols]

I received a document from a new customer in .doc and I opened it in Word
2003. It is columns of data and each item is in its own frame (not text box)
including the titles, headers, footers, column headings etc.

I selected, copied and pasted the portion of the data I needed into Excel
but everything went into column A. I can fix this in Excel by selecting each
6 rows and copy/paste-special/transpose. But with this much data, that's a
lot of rows of 6.

Is there any way to select the data in Word and convert the Frames to a
Table or to text separated by tabs or something to make it easier to work
with? I am not a Word or Excel novice, but this really has me stumped.

 

[Suzanne S. Barnhill]

If the data is really in frames (and not in a table), you may be able to
remove the frames using Ctrl+Q, but this might very well result in a viscous
mass of garbage (Ctrl+Z is your friend!).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Texas Nuckols]

Well, I tried the Ctrl+Q and ended up with each of the frames as a separate
line ending in a paragraph mark. So then I did fall back on Ctrl+Z (undo).
Still need a resolution. Thanks

:

If the data is really in frames (and not in a table), you may be able to
remove the frames using Ctrl+Q, but this might very well result in a viscous
mass of garbage (Ctrl+Z is your friend!).
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Peter T. Daniels]

That sounds like most of the way to what you want -- if each item is a
paragraph, then you can select the entire text, choose Convert Text to
Table, and tell it how many columns to make. Then you can extract the
rows or columns you want from your table.

 

[Suzanne S. Barnhill]

If the lines are at least in order (that is, the same order in which the
frames were displayed to create the "table"), then you could use Table |
Convert | Text to Table, separating at paragraph mark and selecting the
appropriate number of columns. I create tables from lists this way all the
time.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org