Can I switch a Word document to an Excel document

[dancing59]

I have a 58 pg list of names, titles and states typed in Word format that
needs to be converted into an Excel document for sorting It is like this

Title
Name
State

Title
Name
State

Is this possible?

Thanks.

 

[Doug Robbins]

See "Convert Labels into Mail Merge Data File" on fellow MVP Graham Mayor's
website at:

http://www.gmayor.com/convert_labels_into_mail_merge.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[dancing59]

Unfortunately, this is not a label set up. It is simply one line after
another with a double line for name breaks. I don't even know how to make it
into a label set up to try to use your advice. Also, I don't want it to
be a mail merge document. I simply want to put it into an excel database so
that other people can manipulate it at their freedom. They are not even as
computer literate as I and that is not much.

Thanks for your response.

 

[macropod]

Hi,

Yes, you can copy into Excel for sorting, but you'll still need to reformat
the layout before sorting, so that you get each Title, Name & State series
onto a single line.

You might find it just as easy to do in Word, though. For example, if each
Title, Name & State line has a carriage return at the end, and there's an
empty paragraph separating each series, using Find & Replace, to change all
carriage returns to tabs, then all pairs of tabs to carriage returns, would
result in all the data being on one line, ready for sorting.

If you convert the re-formatted data to a table, using the tabs as column
separators, you will then be able to choose whichever of the Title, Name &
State you wanted to use as the primary, secondary and tertiary sorting keys.

After sorting, you could then reverse the conversion and Find & Replace
processes, if you wanted, to restore your original layout whilst retaining
the sorted results.

Cheers

 

[Graham Mayor]

You have obviously looked at the url name of the page and dismissed it. The
page explains how to create a table from text, which is what you asked
about. Locate the point where your document resembles the screen shot and
stop at the table - which you can transfer to Excel.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>