Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
alphabetizing
How does one alphabetize a list (e.g. poems and novels, combined) that
includes some items with leading / trailing parentheses and some that don't? -- Hokie |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
alphabetizing
Can you strip out the punctuation marks?
-- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Wayne" wrote in message ... How does one alphabetize a list (e.g. poems and novels, combined) that includes some items with leading / trailing parentheses and some that don't? -- Hokie |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
alphabetizing
Of course that would make it simple... to alphabetize... but then I'd have to
locate all of the poems among 986 pages of titles and put the quotation marks back. -- Hokie "JoAnn Paules" wrote: Can you strip out the punctuation marks? -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Wayne" wrote in message ... How does one alphabetize a list (e.g. poems and novels, combined) that includes some items with leading / trailing parentheses and some that don't? -- Hokie |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
alphabetizing
So you want to sort but ignore punctuation? I'd be tempted to sort them then
rearrange the others manually. But that's just me. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Wayne" wrote in message ... Of course that would make it simple... to alphabetize... but then I'd have to locate all of the poems among 986 pages of titles and put the quotation marks back. -- Hokie "JoAnn Paules" wrote: Can you strip out the punctuation marks? -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Wayne" wrote in message ... How does one alphabetize a list (e.g. poems and novels, combined) that includes some items with leading / trailing parentheses and some that don't? -- Hokie |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
alphabetizing
You could use a wildcard search to remove the parentheses and quotes
-- and in the same pass to apply, say, a color to the affected lines; then sort the entries; then do another wildcard search to remove the color and replace the parens and quotes. On May 11, 2:40*pm, Wayne wrote: Of course that would make it simple... to alphabetize... but then I'd have to locate all of the poems among 986 pages of titles and put the quotation marks back. -- Hokie "JoAnn Paules" wrote: Can you strip out the punctuation marks? -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Wayne" wrote in message ... How does one alphabetize a list (e.g. poems and novels, combined) that includes some items with leading / trailing parentheses and some that don't? |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
alphabetizing
Does that mean that there is no way to "automatically" do it? If so, then
I'll just have to gut it out... with approximately 50,000 titles to alphabetize, perhaps 1500 of which have quotation marks.... a LOT of hand work. -- Hokie "JoAnn Paules" wrote: So you want to sort but ignore punctuation? I'd be tempted to sort them then rearrange the others manually. But that's just me. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Wayne" wrote in message ... Of course that would make it simple... to alphabetize... but then I'd have to locate all of the poems among 986 pages of titles and put the quotation marks back. -- Hokie "JoAnn Paules" wrote: Can you strip out the punctuation marks? -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Wayne" wrote in message ... How does one alphabetize a list (e.g. poems and novels, combined) that includes some items with leading / trailing parentheses and some that don't? -- Hokie |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
alphabetizing
Wayne,
Well no there is no such thing a wishing Word would do something and it happen automatically. You have to take certain steps. Peter (grammatim) gave you the steps. You could put similar steps in a macro and then run the macro on your list: Sub ScratchMacro() Dim oRng As Word.Range Set oRng = ActiveDocument.Range With oRng.Find .Text = """*""" .MatchWildcards = True .Wrap = wdFindContinue While .Execute oRng.Text = Mid(oRng.Text, 2, Len(oRng.Text) - 2) oRng.Font.Color = wdColorBrightGreen Wend End With ActiveDocument.Range.Sort Set oRng = ActiveDocument.Range With oRng.Find .Font.Color = wdColorBrightGreen .Wrap = wdFindContinue While .Execute oRng.Text = Chr(34) & oRng.Text & Chr(34) oRng.Font.Color = wdColorAutomatic Wend End With End Sub -- Greg Maxey - Word MVP My web site http://gregmaxey.mvps.org Word MVP web site http://word.mvps.org "Wayne" wrote in message ... Does that mean that there is no way to "automatically" do it? If so, then I'll just have to gut it out... with approximately 50,000 titles to alphabetize, perhaps 1500 of which have quotation marks.... a LOT of hand work. -- Hokie "JoAnn Paules" wrote: So you want to sort but ignore punctuation? I'd be tempted to sort them then rearrange the others manually. But that's just me. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Wayne" wrote in message ... Of course that would make it simple... to alphabetize... but then I'd have to locate all of the poems among 986 pages of titles and put the quotation marks back. -- Hokie "JoAnn Paules" wrote: Can you strip out the punctuation marks? -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Wayne" wrote in message ... How does one alphabetize a list (e.g. poems and novels, combined) that includes some items with leading / trailing parentheses and some that don't? -- Hokie |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
alphabetizing
Thanks! This looks like it might work. Will be back later if it doesn't.
-- Hokie "grammatim" wrote: You could use a wildcard search to remove the parentheses and quotes -- and in the same pass to apply, say, a color to the affected lines; then sort the entries; then do another wildcard search to remove the color and replace the parens and quotes. On May 11, 2:40 pm, Wayne wrote: Of course that would make it simple... to alphabetize... but then I'd have to locate all of the poems among 986 pages of titles and put the quotation marks back. -- Hokie "JoAnn Paules" wrote: Can you strip out the punctuation marks? -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Wayne" wrote in message ... How does one alphabetize a list (e.g. poems and novels, combined) that includes some items with leading / trailing parentheses and some that don't? |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
alphabetizing
Greg's macros tend to work first time, every time. (But he didn't add
the link to his "How to load a macro" page!) If you're likely to need to do this more than once, then definitely use the macro. On May 11, 6:17*pm, "Greg Maxey" wrote: Wayne, Well no there is no such thing a wishing Word would do something and it happen automatically. *You have to take certain steps. *Peter (grammatim) gave you the steps. *You could put similar steps in a macro and then run the macro on your list: Sub ScratchMacro() Dim oRng As Word.Range Set oRng = ActiveDocument.Range With oRng.Find * * .Text = """*""" * * .MatchWildcards = True * * .Wrap = wdFindContinue * * While .Execute * * * oRng.Text = Mid(oRng.Text, 2, Len(oRng.Text) - 2) * * * oRng.Font.Color = wdColorBrightGreen * * Wend End With ActiveDocument.Range.Sort Set oRng = ActiveDocument.Range With oRng.Find * .Font.Color = wdColorBrightGreen * .Wrap = wdFindContinue * While .Execute * * oRng.Text = Chr(34) & oRng.Text & Chr(34) * * oRng.Font.Color = wdColorAutomatic * Wend End With End Sub -- Greg Maxey - *Word MVP My web sitehttp://gregmaxey.mvps.org Word MVP web sitehttp://word.mvps.org "Wayne" wrote in message ... Does that mean that there is no way to "automatically" do it? *If so, then I'll just have to gut it out... with approximately 50,000 titles to alphabetize, perhaps 1500 of which have quotation marks.... a LOT of hand work. -- Hokie "JoAnn Paules" wrote: So you want to sort but ignore punctuation? I'd be tempted to sort them then rearrange the others manually. But that's just me. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Wayne" wrote in message ... Of course that would make it simple... to alphabetize... but then I'd have to locate all of the poems among 986 pages of titles and put the quotation marks back. -- Hokie "JoAnn Paules" wrote: Can you strip out the punctuation marks? -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Wayne" wrote in message ... How does one alphabetize a list (e.g. poems and novels, combined) that includes some items with leading / trailing parentheses and some that don't? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alphabetizing Help | Microsoft Word Help | |||
alphabetizing | Microsoft Word Help | |||
Alphabetizing | Microsoft Word Help | |||
alphabetizing | Microsoft Word Help | |||
Alphabetizing | Microsoft Word Help |