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
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
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))),
;
> *“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
>
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
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 quick response once again. Thank you.
Regards
Gaurav Devrani
On Thu, Feb 26, 2015 at 10:16 PM, Paul Schreiner
I don't believe you'll be able to do that with standard Excel functions.
you can create a CUSTOM function using VBA and use it like an Excel function.
In your case, you need to process each character and "switch" the case.
the problem is, within a standard Excel function, there's no way to "proces
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
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
>
