| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I SORT DATA USING A SPECIFIC CHARACTER IN A CELL
I am trying to sort a large excel worksheet using a specific column.
Unfortunately the complication includes the fact that the column is alpha numeric, and that even worse, I am trying to sub sort by a numeric value - the final two digits. ie. A1200-11 A1200-12 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I SORT DATA USING A SPECIFIC CHARACTER IN A CELL
On May 31, 6:06 pm, GEORGE wrote:
I am trying to sort a large excel worksheet using a specific column. Unfortunately the complication includes the fact that the column is alpha numeric, and that even worse, I am trying to sub sort by a numeric value - the final two digits. ie. A1200-11 A1200-12 To get the final two digits of A2 in a separate column as numeric use =--RIGHT(A2,2) Regarding the rest, we need to know HOW you want the numbers sorted. HTH Kostis Vezerides |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to check Cell value within specific character | Excel Discussion (Misc queries) | |||
| Add number from a cell that contains a specific character | Excel Worksheet Functions | |||
| sort starting from a specific character (@ sign) for email addres | Excel Discussion (Misc queries) | |||
| sort data by specific word in cell? | Excel Discussion (Misc queries) | |||
| How do I remove all text in a cell after a specific character? | Excel Worksheet Functions | |||
Linear Mode
