Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi
I have lists of postcodes [zip codes] in cells - many codes together in the same cell - , but only the first two characters. For example: CT, TN, BN, RH, etc etc. There are a lot of them. Could someone tell me how to get Excel to order these alphabetically in each cell that contains them please? Note..this is not about a single code in its own cell but multiple codes in a single cell. Many thanks David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions |