#1
|
|||
|
|||
Aplha Numeric Sorting
Can Excel sort alpha numeric characters?
I attached a spreadsheet that explains how I attempted to sort the cells and how I want it sorted. Any help would be greatly appreciated. Thank you, Karen |
#2
|
|||
|
|||
You must have the column with alphanumeric values formatted as text. Then it'll sort exactly as you wanted.
Simply changing column format is not enough! When you format the column as text, it will behawe as all entries are texts, but really they remain numbers - you have to edit all entries to convert them really (select entry, press F2, Press Enter for every entry). To convert all entries at one go: Into some empty column enter formula like ="" & A2, and copy it down for all entries in column A; Format column A as Text; Copy the range with formulas; Replace old entries in column A with values of copied formulas (PasteSpecial.Values); Delete column with formulas. |
#3
|
|||
|
|||
Thank you so much for your help.
Now if this data is being used for a pivot table, should I sort the raw data first or should it be sorted in the pivot table? Your help is greatly appreciated. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Numeric Values | jrt | Word VBA | 2 | 11-09-2014 01:28 PM |
Use the dot key on the numeric keypad | YooNaa Kim | Word | 2 | 09-09-2013 08:25 AM |
Sorting Alphanumeric & Numeric values | slovenc0417 | Excel | 2 | 06-07-2013 07:58 PM |
Application.OnKey Numeric Plus? | tinfanide | Excel Programming | 6 | 11-26-2012 08:41 PM |
How to do an alpha numeric Sort By? | Opul3nce | Excel | 1 | 10-15-2012 11:11 PM |