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
|
|||
|
|||
In Excel how do you rearrange a list of address's in alphaetical o
I have 165 address's on a spreadsheet which using the post codes i wish to
put into alphabeticval order, how do i acheive this function? |
#2
|
|||
|
|||
In Excel how do you rearrange a list of address's in alphaetical o
Are the parts of the address in separate cells? And you you have headers?
A B C D Street Town Province Pcode 100 Main Street Sometown NS B3J A1D If so, select any cell in the data and use Data Sort and use Pcode as the major sorting 'key' best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "josstex" wrote in message ... I have 165 address's on a spreadsheet which using the post codes i wish to put into alphabeticval order, how do i acheive this function? |
#3
|
|||
|
|||
In Excel how do you rearrange a list of address's in alphaetical o
If the addresses are in a row culminating with the postcode a simple sort
will suffice. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "josstex" wrote: I have 165 address's on a spreadsheet which using the post codes i wish to put into alphabeticval order, how do i acheive this function? |
#4
|
|||
|
|||
In Excel how do you rearrange a list of address's in alphaeticalo
On 5/8/2010 2:40 PM, Bernard Liengme wrote:
Are the parts of the address in separate cells? And you you have headers? A B C D Street Town Province Pcode 100 Main Street Sometown NS B3J A1D If so, select any cell in the data and use Data Sort and use Pcode as the major sorting 'key' best wishes If each entire address is in it's own cell, you can use Data Text to Columns to break the data into separate columns. |
Thread Tools | |
Display Modes | |
|
|