how do I display last two digits of a SSN in a separate column
in [Programming]
|
From: katbone1 on 1 Feb 2010 10:08 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?
From: Mike H on 1 Feb 2010 10:15 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?
From: paul.robinson on 1 Feb 2010 10:19 Hi Use a formula =right(A1, 2) where number is in A1. Now fill down. regards Paul On Feb 1, 3:08 pm, katbone1 <katbo...(a)discussions.microsoft.com> 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?
From: Naftoli on 1 Feb 2010 18:28 =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?
|
Pages: 1 Prev: Automatically hide unused columns Next: Excel Object Not releasing from Task Manager (Vb.net) |