Prev: send color filled shape behind text
Next: How to retrieve the yahoo symbols into excel?
From: NewToExcel on 19 Apr 2010 14:15
You might try using substring to isolate the last work in column A into a new
column. Then you can sort on the new column.

"Father John" wrote:

> Hi
>
> I have a spreadsheet with numerous addresses in col. A 1-999
>
> 15 Smith Street Jonestown
> 21 George Street Blacktown etc.
>
> In col B. 1-166 I have the name of all the suburbs in our region
>
> How can is sort col. A by suburb using the name of the suburbs in Col.B. ?
>
> Any help much appreciated
>
> Regards
> Stephen
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: send color filled shape behind text
Next: How to retrieve the yahoo symbols into excel?