| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding digits in a column based on data in a separate column | Excel Discussion (Misc queries) | |||
| VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
| Sort by even and odd digits and copy to separate worksheet | Excel Worksheet Functions | |||
| Trying to truncate or separate the first 3 characters/digits of co | Excel Discussion (Misc queries) | |||
| separate text and digits within a cell | Excel Programming | |||
Linear Mode
