ignore first 2 characters

Is there anyway to format a cell so that it trims off the first 2 characters
of the cell. For example my cell contains a query that shows PR101 or PL101.
Is there a way to make it just show 101. For this application the PL and PR
don't matter. Am I out of luck on this one or can it be done. Thanks.

got to make a new column (if your #'s are in A, here's the function in B)

= Right(A1,Len(a1)-2)

HTH


*** you aren't related to Jason Sneed (in charlotte)are you?

"Sneed924" wrote:

> Is there anyway to format a cell so that it trims off the first 2 characters
> of the cell. For example my cell contains a query that shows PR101 or PL101.
> Is there a way to make it just show 101. For this application the PL and PR
> don't matter. Am I out of luck on this one or can it be done. Thanks.

Thank you. And no i don't think i am related to Jason. From what i know, i
believe almost all my family is Oklahoma.

"TomHinkle" wrote:

> got to make a new column (if your #'s are in A, here's the function in B)
>
> = Right(A1,Len(a1)-2)
>
> HTH
>
>
> *** you aren't related to Jason Sneed (in charlotte)are you?
>
> "Sneed924" wrote:
>
> > Is there anyway to format a cell so that it trims off the first 2 characters
> > of the cell. For example my cell contains a query that shows PR101 or PL101.
> > Is there a way to make it just show 101. For this application the PL and PR
> > don't matter. Am I out of luck on this one or can it be done. Thanks.