Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Tables / October 2004

Tip: Looking for answers? Try searching our database.

REQ: How to sort 4-line addresses alphabetically

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Stuart Reed - 17 Sep 2004 01:39 GMT
I have hundreds of 4-line addresses (of companies) gathered from several
different sources and would like to be able to create a duplicate list which
shows all the information on one line so that I can sort them
alphabetically. Is there a quick way of doing this?

All help gratefully appreciated.

Stuart Reed
Genine - 17 Sep 2004 12:07 GMT
If the addresses had two blank lines between them, you could do a search and
replace for two paragraph returns (^p), and replace that with a temporary
character, e.g. *.
Then do a second search and replace, and replace your paragraphs/line breaks
at each line of the address with a comma and a space.
Third search and replace would put back the lines between the addresses,
replacing the temporary * character with a paragraph again.

This would give you one line for each address, and then you could sort the
lines alphabetically.

I know it sounds long winded, but sometimes you have to think round corners
to get search and replace to do what you want!
Genine

> I have hundreds of 4-line addresses (of companies) gathered from several
> different sources and would like to be able to create a duplicate list which
[quoted text clipped - 4 lines]
>
> Stuart Reed
Suzanne S. Barnhill - 19 Sep 2004 03:54 GMT
The method I prefer is to replace ^p with ^l, then ^l^l with ^p. This makes
each block a paragraph, with line breaks as required.

Signature

Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> If the addresses had two blank lines between them, you could do a search and
> replace for two paragraph returns (^p), and replace that with a temporary
[quoted text clipped - 19 lines]
> >
> > Stuart Reed
Klaus Linke - 13 Oct 2004 18:39 GMT
Hi Stuart,

Still another method would be to convert the text into a four-colum table
(or five columns if there are empty paragraphs between records).

Then you can sort the table, using any column as the sort key, and later
convert back to text (Table > Convert...).

Regards,
Klaus
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.