how do I display last two digits of a SSN in a separate column

  • Thread starter Thread starter katbone1
  • Start date Start date
K

katbone1

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?
 
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.
 
Hi
Use a formula
=right(A1, 2)

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