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