Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
WindyHill
 
Posts: n/a
Default Want to alphabetize address labels using something other than Mer

Have a large address file on mailing labels . Have tried using Merge to
alphabetize the list, but find this rather cumbersome. Would like to find a
simple quick way to do it. Any suggestions?
  #2   Report Post  
Posted to microsoft.public.excel.charting
BT
 
Posts: n/a
Default Want to alphabetize address labels using something other than Mer

Maybe I'm missing something here, but can't you just select all of the
columns then use Data/Sort... and choose the column that you want to use
to sort by? I have a column in my address list for Last Name and that is
what I use to alphabetize the list.

Merry Christmas


"WindyHill" wrote in message
...
Have a large address file on mailing labels . Have tried using Merge to
alphabetize the list, but find this rather cumbersome. Would like to find
a
simple quick way to do it. Any suggestions?



  #3   Report Post  
Posted to microsoft.public.excel.charting
WindyHill
 
Posts: n/a
Default Want to alphabetize address labels using something other than Mer



"WindyHill" wrote:

Have a large address file on mailing labels . Have tried using Merge to
alphabetize the list, but find this rather cumbersome. Would like to find a
simple quick way to do it. Any suggestions?

  #4   Report Post  
Posted to microsoft.public.excel.charting
WindyHill
 
Posts: n/a
Default Want to alphabetize address labels using something other than Mer



"WindyHill" wrote:

Have a large address file on mailing labels . Have tried using Merge to
alphabetize the list, but find this rather cumbersome. Would like to find a
simple quick way to do it. Any suggestions?

  #5   Report Post  
Posted to microsoft.public.excel.charting
WindyHill
 
Posts: n/a
Default Want to alphabetize address labels using something other than

Do you really think that would work? Are you able to sort using the last
name? My file consists of mail addresses, i.e., Mr & Mrs so and so. Can it
be set up so that the last name is used to sort alphbetically?


"WindyHill" wrote:

Have a large address file on mailing labels . Have tried using Merge to
alphabetize the list, but find this rather cumbersome. Would like to find a
simple quick way to do it. Any suggestions?



  #6   Report Post  
Posted to microsoft.public.excel.charting
WindyHill
 
Posts: n/a
Default Want to alphabetize address labels using something other than



"WindyHill" wrote:



"WindyHill" wrote:

Have a large address file on mailing labels . Have tried using Merge to
alphabetize the list, but find this rather cumbersome. Would like to find a
simple quick way to do it. Any suggestions?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I print address labels from an Excel Spreadsheet sq Excel Worksheet Functions 2 November 2nd 05 04:07 PM
Address Labels - Help! SmokingMirror Excel Discussion (Misc queries) 4 October 5th 05 12:38 PM
Excel 2003 and Labels (NOT Address Labels) Los Excel Discussion (Misc queries) 2 May 4th 05 01:57 PM
Address labels to columns Lady Layla Excel Discussion (Misc queries) 3 February 18th 05 05:28 PM
HOW DO I ENTER TWO NAMES IN ONE ROW FOR ONE ADDRESS FOR LABELS sheilam Excel Discussion (Misc queries) 1 November 30th 04 03:12 PM


All times are GMT +1. The time now is 11:48 PM.

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

About Us

"It's about Microsoft Excel"