Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sort alphabebically ignoring preceeding symbols or numbers
I have a column of data (Excel 2000) which I would like to sort
alphabetically. Some entries have a double asterisk preceeding the first word (**word). I would like to alphabetize ignoring the double asterisk. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alphabetical sort while ignoring preceeding numbers/symbols | Excel Discussion (Misc queries) | |||
Ignoring Initial Articles in Field Sort | Excel Discussion (Misc queries) | |||
Sort order for characters & symbols - does anything follow z? | Excel Discussion (Misc queries) | |||
Sort ignoring negatives and positives | Excel Worksheet Functions | |||
How to sort by day and month while ignoring year? | Excel Worksheet Functions |