Prev: Method of viewing/naming columns or conversions for same
Next: Auto insert sheetname into chart title?
From: Bob Ryan on 8 May 2010 16:54 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. |