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

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?
 
M

Mike H

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.
 
P

paul.robinson

Hi
Use a formula
=right(A1, 2)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Setting column width in a table with a macro is not working 0
How do I remove the top half of a block interval? 1
Finding the right style field in VBA 0
How to center adjust text above and image in a two column document. 1
Possible to Combine reports to's to a single box? 0
How to count the numbers in a Word document? 0
How can I remove the last 8 digits from every number 1

Top