[JR''s PROB]

Hi,

I have a word doc that looks like this:

a href="http://youtube.com/watch?v=jmSUKrhfd94"The Notorious B.I.G. - Big
Poppa/abr
a href="http://youtube.com/watch?v=vw0sF60mtp0"The Shins - Girl on the
Wing/abr
a href="http://youtube.com/watch?v=u0zevGYoF0c"Journey - Separate Ways
(Worlds Apart)/abr


I need to alphabetically sort the names of the songs, which are in between
the html tags, and keep them with their respective html code, so that when I
put them I put the code up on a web page the songs will be listed
alphabetically.

Is there any way this can be done?

I know if there is anyone who can do it you guy's can.

Thanks for looking at this.

[Graham Mayor]

If they are all in that fomat, select the list, replace the character with
Tab
Sort on Field 3
Remove the tab characters ie

With Selection
With .Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = ""
.Replacement.Text = "^9"
.Forward = True
.Wrap = wdFindStop
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
.Execute Replace:=wdReplaceAll
End With
.Sort ExcludeHeader:=False, FieldNumber:="Field 3", SortFieldType _
:=wdSortFieldAlphanumeric, SortOrder:=wdSortOrderAscending
With .Find
.Text = "^9"
.Replacement.Text = ""
.Execute Replace:=wdReplaceAll
End With
End With

This will all fall down if some of the entries are different.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



JR''s PROB wrote:
Hi,

I have a word doc that looks like this:

a href="http://youtube.com/watch?v=jmSUKrhfd94"The Notorious B.I.G.
- Big Poppa/abr
a href="http://youtube.com/watch?v=vw0sF60mtp0"The Shins - Girl on
the Wing/abr
a href="http://youtube.com/watch?v=u0zevGYoF0c"Journey - Separate
Ways (Worlds Apart)/abr


I need to alphabetically sort the names of the songs, which are in
between the html tags, and keep them with their respective html code,
so that when I put them I put the code up on a web page the songs
will be listed alphabetically.

Is there any way this can be done?

I know if there is anyone who can do it you guy's can.

Thanks for looking at this.