Re: How can I sort SSNs in Terminal Digit Order using Excel?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Use the helper column with this formula and then select all and sort on the
helper column.

=RIGHT(A2,2)&MID(A2,8,2)&MID(A2,5,2)&LEFT(A2,2)

Assumes your data starts in row 2

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip>


.

Relevant Pages

  • Re: ummm, ummm, HELP!!!
    ... I then went on to sort the 1's only, ... If you mean that you got the numbers grouped together in the Helper column ... Dim numpoints As Integer ...
    (microsoft.public.excel.misc)
  • Re: ummm, ummm, HELP!!!
    ... Have gotten code to sort in order finally. ... If you mean that you got the numbers grouped together in the Helper column ... Dim numpoints As Integer ...
    (microsoft.public.excel.misc)
  • Re: ummm, ummm, HELP!!!
    ... Have gotten code to sort in order finally. ... If you mean you got that after you sorted on the Helper column then yes ... Dim numpoints As Integer ...
    (microsoft.public.excel.misc)
  • Re: (Primary) Key Column?
    ... disrupt the sequence of rows top to bottom. ... If you want to preserve a list of data so you can sort it and then re- ... sort it back to its original sort order, just insert a helper column ...
    (microsoft.public.excel.misc)
  • Re: Filtering by Colour
    ... As well as using Sort. ... "Peo Sjoblom" wrote in message ... Regards, ... you can sort the data plus the helper column, ...
    (microsoft.public.excel.worksheet.functions)