sorting SS#

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Is there a way to sort in Excel by the last two digits of SS#?

Thanks
 
if the SS# are in column A then in a helper column enter:
=RIGHT(A1,2)*1
copy down and sort by the helper column
 
Hi,
Thanks for the suggestion.
That gave me the last two digits but I'm unable to sort that column.

Bruce
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MATCH AND REPLACE TEXT FROM TWO DIFFERENCE WORKBOOKS 1
Macro security in 2007 5
Change number format 5
Vlookup table error 1
pivot table space question 1
SS tabs reading Dec 1, Dec 2, Dec 3, etc 8
HELP! Lookup 3
MACRO find and Go-To 4

Back
Top