Sorting mail adresses by server?

  • Thread starter Uzmi Novce I Bjezi!
  • Start date
S

Suzanne S. Barnhill

If each address is a separate paragraph and is the only (or first) text in
each paragraph, this would work:

1. Find and Replace @ with @<space> (that is, the @ symbol followed by a
space), which will break each address into two "words."

2. Sort the text by Word 2.

3. Then find @<space> and replace with @.
 
U

Uzmi Novce I Bjezi!

Suzanne S. Barnhill said:
If each address is a separate paragraph and is the only (or first) text in
each paragraph, this would work:

1. Find and Replace @ with @<space> (that is, the @ symbol followed by a
space), which will break each address into two "words."

2. Sort the text by Word 2.

3. Then find @<space> and replace with @.
Click to expand...

Brilliant and deviously genious ;-)

Thank you :)
 
U

Uzmi Novce I Bjezi!

Suzanne S. Barnhill said:
If each address is a separate paragraph and is the only (or first) text in
each paragraph, this would work:

1. Find and Replace @ with @<space> (that is, the @ symbol followed by a
space), which will break each address into two "words."

2. Sort the text by Word 2.

3. Then find @<space> and replace with @.
Click to expand...

But I encountered a little problem - how to do step 2 ? :)

I separated addresses to 'two words' and tried to sort them but I can't do
that.

Can you please tell me the exact steps to sort them by 'second word'?

I have word 2002 (10.2627.2625)
 
S

Suzanne S. Barnhill

This can be tricky. When I select a list of this type, the "Sort by" box
shows "Paragraphs" as the default, but has a down arrow; if you click the
arrow, you get the options of Word 1 and Word 2. But ISTR that sometimes you
don't get these options, at least not the first time you try. If you're not
seeing them, then click on Options, select Other for "Separate fields at"
and type a space in the box. See if that makes a difference.
 
Top