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

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?

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?

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?

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?