sorting SS#

  • Thread starter Thread starter Guest
  • Start date Start date
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
 

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
HELP! Lookup 3
SS tabs reading Dec 1, Dec 2, Dec 3, etc 8
Need help vlookup? 3

Back
Top