Re: $$Excel-Macros$$ Please help me Urgent

2015-03-12 Thread Gaurav Devrani
Dat's Cool Vaibhav. Thanks. On Wed, Mar 11, 2015 at 11:32 PM, Michael Vinoth wrote: > > Very Nice... Mr.Vabz > > On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote: > >> Suppose you have value in cell A1 then type follo. formula in A2 & dont >> press enter & press F9, you will get r

Re: $$Excel-Macros$$ Please help me Urgent

2015-03-11 Thread Michael Vinoth
Very Nice... Mr.Vabz On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote: > Suppose you have value in cell A1 then type follo. formula in A2 & dont > press enter & press F9, you will get result in curly bracket, after = sign > enter CONCATENATE( & press enter to get result > > > =T

Re: $$Excel-Macros$$ Please help me Urgent

2015-03-11 Thread Vaibhav Joshi
Suppose you have value in cell A1 then type follo. formula in A2 & dont press enter & press F9, you will get result in curly bracket, after = sign enter CONCATENATE( & press enter to get result =TRANSPOSE(IF(EXACT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),

Re: $$Excel-Macros$$ Please help me Urgent

2015-02-27 Thread Gaurav Devrani
; > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > *From:* Gaurav Devrani >

Re: $$Excel-Macros$$ Please help me Urgent

2015-02-26 Thread Paul Schreiner
bruary 26, 2015 11:55 AM >Subject: Re: $$Excel-Macros$$ Please help me Urgent > > > >Thanks Paul for your quick reply. Yes I was also trying to create a macro but >Just wanted to confirm before, if that's possible in excel functions. No >worries. I really appreciate your

Re: $$Excel-Macros$$ Please help me Urgent

2015-02-26 Thread Gaurav Devrani
all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Gaurav Devrani > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, February 26, 2015 10:12 AM >

Re: $$Excel-Macros$$ Please help me Urgent

2015-02-26 Thread Paul Schreiner
ong as ever you can.” - John Wesley - > > From: Gaurav Devrani >To: excel-macros@googlegroups.com >Sent: Thursday, February 26, 2015 10:12 AM >Subject: $$Excel-Macros$$ Please help me Urgent > > > >Hi Guys, > > > &

$$Excel-Macros$$ Please help me Urgent

2015-02-26 Thread Gaurav Devrani
Hi Guys, I have a query . In this sentence.. "This iS a tEst" . All Upper case alphabets should be lower case and All Lowercase alphabets should be in Upper case. Please help me . I want that to be done in excel formulas.(If thats possible). Thanks & Regards Gaurav Devrani -- Are you =EXP(E

Re: $$Excel-Macros$$ please help me Urgent

2011-06-07 Thread Sixthsense
Hi Sukumar, I am not sure whether this is what you are looking for.. Have a look in the attached file whether it suits your requirement. --- *Sixthsense **:) Man of Extreme & Innovative Thoughts :)* On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote: > Hi, > > Students English maths sceience

Re: $$Excel-Macros$$ please help me Urgent

2011-06-07 Thread mohd saber
hi sukumar, please find attached. regards, saber On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote: > Hi, > > Students English maths sceience Grades > suresha 45 80 90 90-100 A > srinivas 25 36 60 80-90 b >

$$Excel-Macros$$ please help me Urgent

2011-06-07 Thread vijayajith VA
Hi, Students English maths sceience Grades suresha 45 80 90 90-100 A srinivas 25 36 60 80-90 b sunyana 38 65 70 60-80c sunitha 80 90 68 36-60