Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I rearrange worksheets? | Excel Worksheet Functions | |||
EXcel 2002: How to rearrange data table ? | Excel Discussion (Misc queries) | |||
Address's in Word document into Excel | Excel Discussion (Misc queries) | |||
rearrange data | Excel Discussion (Misc queries) | |||
Can I rearrange data entered in rows into colums in Excel? | Excel Discussion (Misc queries) |