it will help u
=UPPER(LEFT(C3,1))&LOWER(RIGHT(C3,LEN(C3)-1))
with regards
Moksh
2009/6/24 Subu
>
> Dear List members and XL Gurus
>
> I have an XL sheet with a column that looks something like
>
> Name_One
> nAme_two
> NAME_THREE
> name_four
> name_fIVe
&g
; figure to higher 00 level and if last two digits<50, convert the
> > entire figure to lower 00 level
> >
> > Kindly go through the attached file.
> >
> > I use Office 2007 at home and 2003 in office
> >
> > I
d on
> type mentioned in the column.
>
> Attaching the same file.
>
>
> Humble requesting to all of you, to resolve my query.
> *
> Thanks & Regards
&
hed sheet.
> >
> > I need formula for ranking , punches as per day/time
> >
> > Regards,
> >
> > Prashant
> >
> > >
> >
> >
> >
> > --
> > Prashant
> >
>
> >
>
--
Moksh
--~--~-~--~~--
Dear Dilip Pandey
pls do me a favor
Muje koi achi si Excel - VBA ki book recommend kar do jisme questions/
problems bhi ho solve karne ke liye
i will be very greatful for u
with warm regards
Moksh
2009/8/19 Dilip Pandey
> Dear Moksh (krishna.angel15)
>
> Thanks for the encourag
Hi Mr Dilip
moksh this side i need ur help actualy i need to know about the class module
in vba
2009/9/2 Dilip Pandey
> You are always welcome...!!!
>
> Let me know if you need any further help from my side.
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> M
help me?
>
>
> regards
>
> arun
>
> >
>
--
Moksh
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more option
>
> IF C7=540 then it returns 11.
>
> If C7 = 560 then it returns the value from L16 and not 12.
>
> Any ideas why it is not returning the the TRUE value? Is there a
> better method then using nested IF's?
>
> John
>
> >
>
--
Moksh
--~--~-~--~
