Select limited character of a cell
 

..

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

Select limited character of a cell
 

If Dec' 07 is stored as text

=right(A1,2)

if it is being stored as a date

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

--
Regards,
Tom Ogilvy


"Divy" wrote:

..

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

Select limited character of a cell
 

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" wrote in message
oups.com...
.

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

Select limited character of a cell
 

On Nov 5, 7:04 pm, Tom Ogilvy
wrote:
If Dec' 07 is stored as text

=right(A1,2)

if it is being stored as a date

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

--
Regards,
Tom Ogilvy

"Divy" wrote:
..

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

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

:-)