Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2017, 03:19 PM
vrflash vrflash is offline How do I sort entries alphabetically by the last name and then automatically number the addresses Windows 10 How do I sort entries alphabetically by the last name and then automatically number the addresses Office 2003
Novice
How do I sort entries alphabetically by the last name and then automatically number the addresses
 
Join Date: Sep 2017
Posts: 2
vrflash is on a distinguished road
Default How do I sort entries alphabetically by the last name and then automatically number the addresses

Word experts,



I have a bunch of addresses in this format:

first name last name
address

space

first name last name
address

How do I sort them alphabetically by the last name and then automatically number the addresses

1. first name last name
address

2. first name last name
address


Thank you
Reply With Quote
  #2  
Old 09-06-2017, 04:45 PM
macropod's Avatar
macropod macropod is offline How do I sort entries alphabetically by the last name and then automatically number the addresses Windows 7 64bit How do I sort entries alphabetically by the last name and then automatically number the addresses Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You could insert tabs between the first name & last name, plus replace any line/paragraph breaks between them and the addresses with tabs, then convert the lot to a table and sort that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-07-2017, 05:14 PM
vrflash vrflash is offline How do I sort entries alphabetically by the last name and then automatically number the addresses Windows 10 How do I sort entries alphabetically by the last name and then automatically number the addresses Office 2003
Novice
How do I sort entries alphabetically by the last name and then automatically number the addresses
 
Join Date: Sep 2017
Posts: 2
vrflash is on a distinguished road
Default Thank you

Thank you Paul.
Reply With Quote
Reply

Tags
numbering, sorting

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I sort entries alphabetically by the last name and then automatically number the addresses VBA Dropdown change list Entries automatically QA_Compliance_Advisor Word VBA 20 09-16-2014 07:29 AM
How do I sort entries alphabetically by the last name and then automatically number the addresses Captions automatically updating all previous entries jhats Word 1 07-29-2014 11:53 PM
Sort bibliopgraphy alphabetically. Delian87 Word 1 03-28-2014 01:30 PM
How do I sort entries alphabetically by the last name and then automatically number the addresses How to sort the styles alphabetically? Jamal NUMAN Word 1 04-14-2011 01:53 PM
Update from 2003 outlook to 2007 Cannot sort contacts alphabetically mestisoz Outlook 11 02-21-2011 02:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft