| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how can I sort alphanumeric entries by number in excel
I need to sort a column of alphanumic numbers in EXCEL with it ignoring the
prefix letters. |
|
#2
|
|||
|
|||
|
how can I sort alphanumeric entries by number in excel
Create a new column and extract the digits from the other cell. Then sort by
that column. If your data looks like: XX#### (always two alphas followed by the numbers) it might be as simple as: =--mid(A1,3,255) Other formulas would depend on what your data looks like. You may want to post a representative sample. beasleyb wrote: I need to sort a column of alphanumic numbers in EXCEL with it ignoring the prefix letters. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel won't sort numbers correctly | Excel Discussion (Misc queries) | |||
| How do I sort for the maximum values in each year in excel? | Excel Discussion (Misc queries) | |||
| How to sort/update large excel db | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
| how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Hybrid Mode
