[Pamelia Caswell via OfficeKB.com]

This works in W2007:

Select the whole list. Click sort Options. Select the "Other" radio button
and enter a hyphen in the box.
Back in the Sort Text dialog, set the sort by to "Field 2"and click OK.

If that won't work with your version , this longer method should:Temporarily
replace the hyphens with tabs (^t). Convert the tabbed list to a three-
column table. Sort the table on the second column. Then convert the table
back to a tabbed list and replace the tabs with hyphens.

Pam

Jgrant wrote:
Sorry for the absense. Life caught up with me for a bit.

Thank you so much for the macro. I have another question:

Would you happen to know a way that I could get it to take all th
lines that contain shop[1], and group all them together. Then I ca
repeat that for shop[2], shop[3], etc, and have them all grouped tha
way?

I've been doing it manually, and it's a pain.

Doug Robbins;431429 Wrote:
Use a macro containing the following code:

[quoted text clipped - 69 lines]
viewers
would be capable of reading it.

--
Jgrant

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...gdocs/200909/1