Select limited character of a cell

[Divy]

..

hi Techies

One small solution required here...

I have entered "Dec' 07" in a cell.

And i only require to display 07 in another cell.

Please suggest some formula for the same.

Cheers!!!
Divy

 

[Guest]

If Dec' 07 is stored as text

=right(A1,2)

if it is being stored as a date

=Text(year(A1),"00")

 

[Otto Moehrbach]

Another way.
Say the date is in A1 and you want the year only in B1.
In B1 type "=A1" without the quotes.
Format B1 as Custom, and enter "yy" without the quotes, in "Type". HTH
Otto

 

[Divy]

If Dec' 07 is stored as text

=right(A1,2)

if it is being stored as a date

=Text(year(A1),"00")

Thanks for the help, it shows the result as Dec' 07.