| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting alphanumeric data at 2nd, 3rd or 4th character position
I am trying to sort the following data (for example):
PL00/1235 PL04/1111 PL05/3211 PL88/0463 PL97/8546 PL99/2134 PROF02/5555 PROF05/6743 PROF06/7952 PROF88/1623 PROF97/1236 PROF99/1644 MED89/5263 MED97/2563 MED01/1256 MED05/1333 I would like to be able to sort by firstly the numbers following the letters (which indicates the year) and secondly alphabetically by the letters in front of those years (ie PL,PROF,MED) and thirdly by the number following the forward stroke (/). Does anyone know how this might be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find position of first non-matching character | Excel Worksheet Functions | |||
| Generating a random 17-character alphanumeric string | Excel Discussion (Misc queries) | |||
| Sorting Alphanumeric data in Excel 2003 | Setting up and Configuration of Excel | |||
| sort on character position | Excel Worksheet Functions | |||
| locking data/cells so re-sorting a column doesn't re-position my d | Excel Discussion (Misc queries) | |||
Threaded Mode
