Windows 10: How To Sort Microsoft Excel Cells Alphanumerically?

Hello all,

Long time no see. Been gone for a while, but now I need some help

Let's say that I have an Excel table:

Name
Marge
Maggie
Lisa
Homer
Bart

How can I sort the column so that it results in:

Name
Bart
Homer
Lisa
Maggie
Marge

I've found some tutorials elsewhere, but it doesn't explain how to keep Name at the top.

:)

 

MS Excel - Sorting text cells

1. Insert a blank column next to the one with your numbers 1,1a etc
2. In that new column use a formula which is Code:
   where A2 is the cell reference of the first value in the catalogue numbers column (in my example it's in the first column)
3. copy that formula down to all rows
4. Add a title to the top of the new column, eg. 'Sorter'
5. Select all the data range, and from the Data bit of the Ribbon, select the Sort option (not using an Autofilter), and select to sort on the new Sorter column
6. You should get a dialog popping up saying the sort key may not sort as expected because it contains some numbers formatted as text. In this, choose the option to 'Sort numbers and numbers stored as text separately'.

This should sort in the order 1,1a,1b,2,2a etc.

 

MS Excel - Sorting text cells

It's a feature, see MS description and attempted solutions here:
https://support.microsoft.com/en-us/...-data-in-excel
Worksheet design needs to comply with excel features.
For stamps you might need several columns such as country, some subdivision, year, something about the stamp. Follow with multicolumn sort.
Now, if it really is of the 1,2,1a,… type, AND if only one lower case letter is used then this mad formula converts letters of what's in column A to a number after a decimal point.
Multiply makes it a number otherwise excel might still treat it as text.
IF(ISNUMBER($A2),$A2,LEFT($A2,LEN($A2)-1)&"."&CODE(RIGHT($A2,1))-96)
Just couldn't resist joining the fun of playing with it

 

Excel: how to sort columns

I don't think Sort will achieve what you want. A sort will sort the individual cell contents by Row or by Column (Custom sort options: sort Top to Bottom or Left to Right). Depending of the data in each cell you could end up shuffling the cells so that in each column you may end up with cells that were originally in several different columns.





As I understand it you want to rearrange the columns so that all the cells contained in column CS_S are moved to the first column, shifting the rest of the columns one column to the right. For that you'll need to do it manually. Select an entire column, right-click on it and cut it, then insert it where you want it to appear.