LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
jillysillybilly
 
Posts: n/a
Default How do I list postcodes in order in Excel?

I have a list in Excel that I need to sort by postcodes, but in its current
format, the postcodes (Column A) go like this, eg: BA1 then BA10 BA11 BA12
etc then BA2, but I want them to go BA1 BA2 BA3 etc. How do I do this?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Address List in Excel getalife Excel Discussion (Misc queries) 2 May 29th 06 03:58 PM
CREATE LIST OBJECT IN EXCEL MIKE Excel Worksheet Functions 0 June 20th 05 08:13 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
list of all excel 2000functions R.VENKATARAMAN Excel Discussion (Misc queries) 3 June 13th 05 05:33 AM
Excel List to Table frtklau Excel Discussion (Misc queries) 1 February 17th 05 08:15 PM


All times are GMT +1. The time now is 11:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"