A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Alphabetizing text



 
 
Thread Tools Display Modes
  #1  
Old November 2nd, 2005, 09:41 PM
Jeff
external usenet poster
 
Posts: n/a
Default Alphabetizing text

I plan to scan a list of names and convert it into text which I will import
into Word 2002. Is there a way for Word to sort this list based on the
second word (which is the surname) in each line rather than the first word?

Thanks.

--

Jeff



  #2  
Old November 2nd, 2005, 11:10 PM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default Alphabetizing text

Yes, provided it's *always* the second word, Word can search on "Word 2."
Sometimes you have to try several times to make it display this option,
however, and it helps to select a space as the field separator.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Jeff" wrote in message
...
I plan to scan a list of names and convert it into text which I will

import
into Word 2002. Is there a way for Word to sort this list based on the
second word (which is the surname) in each line rather than the first

word?

Thanks.

--

Jeff




  #3  
Old November 3rd, 2005, 04:27 AM
Jeff
external usenet poster
 
Posts: n/a
Default Alphabetizing text

I'm not sure I understand. You say "search" but I am wondering if sort (not
search) can occur based on the second word. The only sort I can find in
Word is under "Table" and it does not have an option to use the second word
(that I can find).

Jeff

Suzanne S. Barnhill wrote:
Yes, provided it's *always* the second word, Word can search on "Word
2." Sometimes you have to try several times to make it display this
option, however, and it helps to select a space as the field
separator.


"Jeff" wrote in message
...
I plan to scan a list of names and convert it into text which I will
import into Word 2002. Is there a way for Word to sort this list
based on the second word (which is the surname) in each line rather
than the first word?

Thanks.

--

Jeff



  #4  
Old November 3rd, 2005, 07:14 AM
Graham Mayor
external usenet poster
 
Posts: n/a
Default Alphabetizing text

This is a bit tricky to explain. The sort tool (table sort) by default
will show sort by paragraphs or fields when not used in a table. Select
'fields' and under 'options' set the field separator to space. This will
change 'fields' to Word1. Run the sort and quit the sort tool. Then run the
sort tool again and you should find that you now have further choices. As
Suzanne indicates, it can be a bit fiddly.

--

Graham Mayor - Word MVP

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


Jeff wrote:
I'm not sure I understand. You say "search" but I am wondering if
sort (not search) can occur based on the second word. The only sort
I can find in Word is under "Table" and it does not have an option to
use the second word (that I can find).

Jeff

Suzanne S. Barnhill wrote:
Yes, provided it's *always* the second word, Word can search on "Word
2." Sometimes you have to try several times to make it display this
option, however, and it helps to select a space as the field
separator.


"Jeff" wrote in message
...
I plan to scan a list of names and convert it into text which I will
import into Word 2002. Is there a way for Word to sort this list
based on the second word (which is the surname) in each line rather
than the first word?

Thanks.

--

Jeff



  #5  
Old November 3rd, 2005, 12:10 PM
Jeff
external usenet poster
 
Posts: n/a
Default Alphabetizing text

Aha! Thank you Graham.

Jeff

Graham Mayor wrote:
This is a bit tricky to explain. The sort tool (table sort) by
default will show sort by paragraphs or fields when not used in a
table. Select 'fields' and under 'options' set the field separator to
space. This will change 'fields' to Word1. Run the sort and quit the
sort tool. Then run the sort tool again and you should find that you
now have further choices. As Suzanne indicates, it can be a bit
fiddly.

Jeff wrote:
I'm not sure I understand. You say "search" but I am wondering if
sort (not search) can occur based on the second word. The only sort
I can find in Word is under "Table" and it does not have an option to
use the second word (that I can find).

Jeff

Suzanne S. Barnhill wrote:
Yes, provided it's *always* the second word, Word can search on
"Word 2." Sometimes you have to try several times to make it display
this
option, however, and it helps to select a space as the field
separator.


"Jeff" wrote in message
...
I plan to scan a list of names and convert it into text which I
will import into Word 2002. Is there a way for Word to sort this
list based on the second word (which is the surname) in each line
rather
than the first word?

Thanks.

--

Jeff



  #6  
Old November 3rd, 2005, 05:54 PM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default Alphabetizing text

Yes, sorry, "search" was a typo (I think).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Jeff" wrote in message
...
Aha! Thank you Graham.

Jeff

Graham Mayor wrote:
This is a bit tricky to explain. The sort tool (table sort) by
default will show sort by paragraphs or fields when not used in a
table. Select 'fields' and under 'options' set the field separator to
space. This will change 'fields' to Word1. Run the sort and quit the
sort tool. Then run the sort tool again and you should find that you
now have further choices. As Suzanne indicates, it can be a bit
fiddly.

Jeff wrote:
I'm not sure I understand. You say "search" but I am wondering if
sort (not search) can occur based on the second word. The only sort
I can find in Word is under "Table" and it does not have an option to
use the second word (that I can find).

Jeff

Suzanne S. Barnhill wrote:
Yes, provided it's *always* the second word, Word can search on
"Word 2." Sometimes you have to try several times to make it display
this
option, however, and it helps to select a space as the field
separator.


"Jeff" wrote in message
...
I plan to scan a list of names and convert it into text which I
will import into Word 2002. Is there a way for Word to sort this
list based on the second word (which is the surname) in each line
rather
than the first word?

Thanks.

--

Jeff




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking text boxes Volunteer Mom Publisher 7 November 12th, 2008 01:29 AM
Formulas dealing with text data Bagia Worksheet Functions 6 June 20th, 2005 10:29 PM
Ideas On Producing Envelopes & Labels For Data RNUSZ@OKDPS Setting Up & Running Reports 0 April 28th, 2005 03:22 PM
Access reports with a horizontal line after each record??? Bill via AccessMonster.com Setting Up & Running Reports 6 March 9th, 2005 04:51 PM
Concatenatd fields in a query for a searching form Marc Running & Setting Up Queries 8 October 19th, 2004 08:49 PM


All times are GMT +1. The time now is 08:15 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.