| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
| how to select the first character in a cell and delete the rest | Excel Worksheet Functions | |||
| Limited character display | Excel Discussion (Misc queries) | |||
| Macro Print to file limited the no of character in a row? | Excel Programming | |||
| Macro Print to file limited the no of character in a row? | Excel Programming | |||
Linear Mode
