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?
|