address book

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

naestoi

Thread Starter
Joined
Nov 3, 2011
Messages
4
trying to do an address book how to make the name and address in accending order
 

naestoi

Thread Starter
Joined
Nov 3, 2011
Messages
4
Hi! How do I make an alphabetical address book with an Excel spreadsheet? I already have all my addresses in a spreadsheet....I was just wondering how I could make them in alphabetical order using a formula, etc.
 

valis

Moderator
Joined
Sep 24, 2004
Messages
78,159
alphabetical by how? If the first and last names are in the same cell, it will alphabetize them by first name. What data do you have?
 

naestoi

Thread Starter
Joined
Nov 3, 2011
Messages
4
last name, first, address, city, st, zip, phone, cell, email

is the only way for this to happen is going straight across and can not be done in just two or three columns up and down
 

valis

Moderator
Joined
Sep 24, 2004
Messages
78,159
is all that data in one cell, or is it split amongst cells? I.E., one cell for the last name, one for the first name, one for the address, etc.
 

valis

Moderator
Joined
Sep 24, 2004
Messages
78,159
in that case, just sort it how you wish. You can arrange the columns however you wish and then sort to your own criteria.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top