[Wayne]

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

[JoAnn Paules]

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

[Wayne]

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

[JoAnn Paules]

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

[grammatim[_2_]]

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?

[Wayne]

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

[Greg Maxey[_2_]]

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

[Wayne]

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?

[grammatim[_2_]]

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?