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  

Need help sorting and need a real pro - this is a toughy.



 
 
Thread Tools Display Modes
  #1  
Old December 29th, 2008, 10:08 PM posted to microsoft.public.word.newusers
Terri[_2_]
external usenet poster
 
Posts: 42
Default Need help sorting and need a real pro - this is a toughy.

Perhaps someone can tell me how to sort this list:
1. joe smith 1 main st someplace ny 11300
2. mary jones 2 central ave anywhere ny 11456

and so forth. I would like to sort them in alphabetical order by first or
last name and have the rest of the information appear as well. If necessary,
I can eliminate the numbers preceding the name. I could have a list of up to
50 to sort. I use Word 2003 and Windows XP Pro.
Thanks so much.


  #2  
Old December 29th, 2008, 11:20 PM posted to microsoft.public.word.newusers
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Need help sorting and need a real pro - this is a toughy.

Remove the numbers. To sort by first name, use Table | Sort and choose
Paragraph. To sort by last name, select space as the field separator and
sort on Word 1.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Terri" wrote in message
...
Perhaps someone can tell me how to sort this list:
1. joe smith 1 main st someplace ny 11300
2. mary jones 2 central ave anywhere ny 11456

and so forth. I would like to sort them in alphabetical order by first or
last name and have the rest of the information appear as well. If
necessary, I can eliminate the numbers preceding the name. I could have a
list of up to 50 to sort. I use Word 2003 and Windows XP Pro.
Thanks so much.




  #3  
Old December 29th, 2008, 11:57 PM posted to microsoft.public.word.newusers
Terri[_2_]
external usenet poster
 
Posts: 42
Default Need help sorting and need a real pro - this is a toughy.

Tried it - does not work....


"Suzanne S. Barnhill" wrote in message
...
Remove the numbers. To sort by first name, use Table | Sort and choose
Paragraph. To sort by last name, select space as the field separator and
sort on Word 1.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Terri" wrote in message
...
Perhaps someone can tell me how to sort this list:
1. joe smith 1 main st someplace ny 11300
2. mary jones 2 central ave anywhere ny 11456

and so forth. I would like to sort them in alphabetical order by first or
last name and have the rest of the information appear as well. If
necessary, I can eliminate the numbers preceding the name. I could have a
list of up to 50 to sort. I use Word 2003 and Windows XP Pro.
Thanks so much.






  #4  
Old December 30th, 2008, 12:24 AM posted to microsoft.public.word.newusers
Steve[_57_]
external usenet poster
 
Posts: 598
Default Need help sorting and need a real pro - this is a toughy.

Hello Terri.

Your list could easily be transformed into a simple database application.
First name, last name, address, city, state and zipcide would be stored as
separate fields in the database and you could sort ascending or descending
on any field. The sorted list could be displayed on-screen and/or printed
out. If you think this might work better for you and/or if you have
questions, contact me at . I could build this database for
you for a very modest fee.

Steve

"Terri" wrote in message
...
Perhaps someone can tell me how to sort this list:
1. joe smith 1 main st someplace ny 11300
2. mary jones 2 central ave anywhere ny 11456

and so forth. I would like to sort them in alphabetical order by first or
last name and have the rest of the information appear as well. If
necessary, I can eliminate the numbers preceding the name. I could have a
list of up to 50 to sort. I use Word 2003 and Windows XP Pro.
Thanks so much.



  #5  
Old December 30th, 2008, 12:54 AM posted to microsoft.public.word.newusers
PamC via OfficeKB.com
external usenet poster
 
Posts: 585
Default Need help sorting and need a real pro - this is a toughy.

I think Suzanne meant to write "word 2". It works in W2007 — & should work
in W2003 & before —as long as you don't have middle names or initials.

PamC



Suzanne S. Barnhill wrote:
Remove the numbers. To sort by first name, use Table | Sort and choose
Paragraph. To sort by last name, select space as the field separator and
sort on Word 1.

Perhaps someone can tell me how to sort this list:
1. joe smith 1 main st someplace ny 11300

[quoted text clipped - 5 lines]
list of up to 50 to sort. I use Word 2003 and Windows XP Pro.
Thanks so much.


--
Message posted via http://www.officekb.com

  #6  
Old December 30th, 2008, 04:22 AM posted to microsoft.public.word.newusers
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Need help sorting and need a real pro - this is a toughy.

Indeed I did. Thanks, Pam.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"PamC via OfficeKB.com" u43222@uwe wrote in message
news:8f693518b56c4@uwe...
I think Suzanne meant to write "word 2". It works in W2007 - & should work
in W2003 & before -as long as you don't have middle names or initials.

PamC



Suzanne S. Barnhill wrote:
Remove the numbers. To sort by first name, use Table | Sort and choose
Paragraph. To sort by last name, select space as the field separator and
sort on Word 1.

Perhaps someone can tell me how to sort this list:
1. joe smith 1 main st someplace ny 11300

[quoted text clipped - 5 lines]
list of up to 50 to sort. I use Word 2003 and Windows XP Pro.
Thanks so much.


--
Message posted via http://www.officekb.com



  #7  
Old December 30th, 2008, 09:17 AM posted to microsoft.public.word.newusers
Gordon[_10_]
external usenet poster
 
Posts: 2,460
Default Need help sorting and need a real pro - this is a toughy.

"Terri" wrote in message
...
Perhaps someone can tell me how to sort this list:
1. joe smith 1 main st someplace ny 11300
2. mary jones 2 central ave anywhere ny 11456

and so forth. I would like to sort them in alphabetical order by first or
last name and have the rest of the information appear as well. If
necessary, I can eliminate the numbers preceding the name. I could have a
list of up to 50 to sort. I use Word 2003 and Windows XP Pro.
Thanks so much.



What is the purpose of this list? You might be better off using a
spreadsheet application rather than a WP one. Depends on what you are using
the data for...

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

  #8  
Old December 30th, 2008, 03:54 PM posted to microsoft.public.word.newusers
Terri[_2_]
external usenet poster
 
Posts: 42
Default Need help sorting and need a real pro - this is a toughy.

I can't use Excel for this as it is simply a list which I fax daily but
would like it sorted. It still is not working at all with the instructions
given. Any other suggestions?


"Gordon" wrote in message
...
"Terri" wrote in message
...
Perhaps someone can tell me how to sort this list:
1. joe smith 1 main st someplace ny 11300
2. mary jones 2 central ave anywhere ny 11456

and so forth. I would like to sort them in alphabetical order by first or
last name and have the rest of the information appear as well. If
necessary, I can eliminate the numbers preceding the name. I could have a
list of up to 50 to sort. I use Word 2003 and Windows XP Pro.
Thanks so much.



What is the purpose of this list? You might be better off using a
spreadsheet application rather than a WP one. Depends on what you are
using the data for...

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)



  #9  
Old December 30th, 2008, 04:44 PM posted to microsoft.public.word.newusers
Gordon[_10_]
external usenet poster
 
Posts: 2,460
Default Need help sorting and need a real pro - this is a toughy.

"Terri" wrote in message
...
I can't use Excel for this as it is simply a list which I fax daily


So why does that preclude Excel?

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

  #10  
Old December 30th, 2008, 06:31 PM posted to microsoft.public.word.newusers
Steve[_57_]
external usenet poster
 
Posts: 598
Default Need help sorting and need a real pro - this is a toughy.

Terri,

FYI, if you did your contacts in a database, it could easily be faxed! A
database would be much easier for you than doing your list in Word.

Steve


"Terri" wrote in message
...
I can't use Excel for this as it is simply a list which I fax daily but
would like it sorted. It still is not working at all with the instructions
given. Any other suggestions?


"Gordon" wrote in message
...
"Terri" wrote in message
...
Perhaps someone can tell me how to sort this list:
1. joe smith 1 main st someplace ny 11300
2. mary jones 2 central ave anywhere ny 11456

and so forth. I would like to sort them in alphabetical order by first
or last name and have the rest of the information appear as well. If
necessary, I can eliminate the numbers preceding the name. I could have
a list of up to 50 to sort. I use Word 2003 and Windows XP Pro.
Thanks so much.



What is the purpose of this list? You might be better off using a
spreadsheet application rather than a WP one. Depends on what you are
using the data for...

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)





 




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


All times are GMT +1. The time now is 09:35 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.