Thread: how do I display last two digits of a SSN in a separate column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
  
Posts: 789
Default how do I display last two digits of a SSN in a separate column
Hi
Use a formula
=right(A1, 2)

where number is in A1. Now fill down.
regards
Paul

On Feb 1, 3:08*pm, 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