| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sort AlphaNumeric Data sequentially with spaces
Hello,
Tom already gave you a VBA solution. An approach with worksheet functions: Write into B1: =IF(ISERROR(MATCH("D"&TEXT(ROW(),"00000"),$A$1:$A $9999,)),"",VLOOKUP("D"&TEXT(ROW(),"00000"),$A$1:$ A$9999,1,)) and copy down. Regards, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort AlphaNumeric Data sequentially with spaces | Excel Discussion (Misc queries) | |||
| alphanumeric sort | Excel Discussion (Misc queries) | |||
| sort alphanumeric data | New Users to Excel | |||
| Sort - alphanumeric. | New Users to Excel | |||
| Alphanumeric Sort | Excel Discussion (Misc queries) | |||
Threaded Mode
