Thread: how do I display last two digits of a SSN in a separate column
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Naftoli Naftoli is offline
external usenet poster
  
Posts: 7
Default how do I display last two digits of a SSN in a separate column
=right(a1,2)
--
Naftoli


"katbone1" wrote:

I am trying to create a formula to take an existing list of 8 or 9 digit
numbers and display the last two numbers in a separate column. Is this
possible?
Reply With QuoteReply With Quote