Try
a1B1c1
1-Jan-04 31-Mar-04 0 2-Jan-04 1-Apr-05 1 2
[c1] =DATEDIF(A1, B1, "Y")
On Sun, Sep 21, 2008 at 9:57 AM, vivek jain <[EMAIL PROTECTED]> wrote:
>
>
> Dear All,
> I am preparing a fixed asset register for the last fifty years for an
> organi
You can change text in upper case / lower case/
On Sat, Sep 20, 2008 at 5:22 PM, vinay keni <[EMAIL PROTECTED]> wrote:
> dear all,
>
> i want to know how to change from small letters to capital
> letters as i have some 500 persons name which i have typed in small letters
> now wants to
Or u can use =proper(cell reference)
On Sun, Sep 21, 2008 at 9:58 AM, Manish Purohit <[EMAIL PROTECTED]> wrote:
> Use UPPER(Cell reference).
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> [EMAIL PROTECTED] *On Behalf Of *vinay keni
> *Sent:* Saturday, September 20, 2008 5:22 PM
> *To
Just use PROPER() or go to similar formulae.
On Sep 20, 2:52 pm, "vinay keni" <[EMAIL PROTECTED]> wrote:
> dear all,
>
> i want to know how to change from small letters to capital letters
> as i have some 500 persons name which i have typed in small letters now
> wants to change those
For changing text from small letter to capital letter. Use the formula
=Upper(range)
For changing text from capital letter to small letter. Use the formula
=Lower(range)
For changing text from any (small or capital letter) to proper way. as
first letter capital and rest small. then use formula =Pro
Hi,
Just use this formula =upper(cell reference)
On Sat, Sep 20, 2008 at 5:22 PM, vinay keni <[EMAIL PROTECTED]> wrote:
> dear all,
>
> i want to know how to change from small letters to capital
> letters as i have some 500 persons name which i have typed in small letters
> now wants t
