Re: $$Excel-Macros$$ Seeking help small letters to capital letters

2011-11-14 Thread Sanjib Chatterjee
=UPPER(A1) 2011/11/10 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ < vadnalaki...@gmail.com> > Hi > > Anybody can help me out > how to make small letter to capital letter in Ms excel > > V.Kiran > > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thre

Re: $$Excel-Macros$$ Seeking help small letters to capital letters

2011-11-11 Thread NOORAIN ANSARI
Dear Kiran, You can use in VBA Version for Selection Range, *Sub uppercase() Dim abc As Range For Each abc In Selection abc.Value = VBA.UCase(abc) Next End Sub * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansa

Re: $$Excel-Macros$$ Seeking help small letters to capital letters

2011-11-10 Thread Krishna
Dear Kiran, Use "=upper(cell reference)" Sent from my iPhone On 10-Nov-2011, at 9:00 PM, ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ wrote: > Hi > > Anybody can help me out > how to make small letter to capital letter in Ms excel > > V.Kiran > > > -- > FORUM RULES (934+ members already

Re: $$Excel-Macros$$ Seeking help small letters to capital letters

2011-11-10 Thread chhajersandeep
Sorry Kiran it sud be upper(text) Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: .•:*¨¨*:•. .•:V.Kiran Kumar :•. .•:* ¨¨*:•. vadnalaki...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 10 Nov 2011 17:30:20 To: Reply-To: excel-macr

Re: $$Excel-Macros$$ Seeking help small letters to capital letters

2011-11-10 Thread chhajersandeep
Use funtion Lower(text) Or Proper (text) Sandeep Chhajer Sent on my BlackBerry® from Vodafone -Original Message- From: .•:*¨¨*:•. .•:V.Kiran Kumar :•. .•:* ¨¨*:•. vadnalaki...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 10 Nov 2011 17:30:20 To: Reply-To: exc