Thread: how do I display last two digits of a SSN in a separate column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default how do I display last two digits of a SSN in a separate column
Try

=RIGHT(A1,2)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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