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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to sort by last name for name tags.
How can I sort by last name for name tags? I only have one option under
"Using" and that is paragraphs. |
#2
|
|||
|
|||
How to sort by last name for name tags.
The easiest way is to put the last name into a separate column, or to
separate the first and last name by commas. So, if you have: Mickey Mouse Donald Duck (no middle initials) You should be able to find/replace spaces with commas, sort the data by the last name, and then find commas and replace with spaces. I'm just guessing, tho, since you didn't tell us what your data looks like. ************ Anne Troy www.OfficeArticles.com "name tags" name wrote in message ... How can I sort by last name for name tags? I only have one option under "Using" and that is paragraphs. |
#3
|
|||
|
|||
How to sort by last name for name tags.
Why would you replace the spaces with commas? You can sort on Word 2 without
that. -- 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. "Anne Troy" wrote in message ... The easiest way is to put the last name into a separate column, or to separate the first and last name by commas. So, if you have: Mickey Mouse Donald Duck (no middle initials) You should be able to find/replace spaces with commas, sort the data by the last name, and then find commas and replace with spaces. I'm just guessing, tho, since you didn't tell us what your data looks like. ************ Anne Troy www.OfficeArticles.com "name tags" name wrote in message ... How can I sort by last name for name tags? I only have one option under "Using" and that is paragraphs. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort Ascending button - Excel 2003 | bigwheel | General Discussion | 1 | May 23rd, 2005 11:10 PM |
SORT BY DOMAIN, SORT BY HOST, MULTIPLE WINDOWS | YourDisplayNameHere | General Discussion | 1 | April 28th, 2005 08:36 PM |
Inserting a new record into an existing table | Ravenlock | New Users | 4 | April 25th, 2005 02:34 PM |
Excel Sort() Algorithm | Michael C | Worksheet Functions | 14 | August 2nd, 2004 07:31 AM |
Setting up a Command Button to sort | Frank Kabel | Worksheet Functions | 2 | May 22nd, 2004 06:24 PM |