From: katbone1 on
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
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
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
=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?