Sorting information within a cell.

  • Thread starter Thread starter Bridget
  • Start date Start date
B

Bridget

I have 3 colums of information. One of the colums contains SSN's. I need to
sort by the last 2 digits of the SSN and I can't seem to fiqure out how to do
this. Any help would be greatly appreciated.
 
Assume SSN is in column D. Put this formula in a helper column:

=RIGHT(D2,2)*1

and copy down. Then include this helper column in your sort area and
sort by the helper column.

Multiplying by 1 converts the extracted digits to real numbers, so
that your sort makes sense.

Hope this helps.

Pete
 
I have 3 colums of information. One of the colums contains SSN's. I need to
sort by the last 2 digits of the SSN and I can't seem to fiqure out how todo
this. Any help would be greatly appreciated.
Click to expand...


Try this:
In a new column, put this formula to show only the last two digits of
SSN: =RIGHT(cell number,2)
~Where it says "Cell" simple left click once in the SSN cell that
contains the number beside this formula.
~Where it shows the number "2", make sure and put a comma beside it
and then the number two.

Hope this helps. This should work on the numbers even if they have
the dash inbetween the three sections of the SSN.
 
Back
Top