$$Excel-Macros$$ first letter to be Capital letter

2016-01-21 Thread Vinod Kumar
Dear Team, Pls. asst. how to change first letter of a word to Cap's, in multiple cell. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

Re: $$Excel-Macros$$ first letter to be Capital letter

2016-01-21 Thread Vinod Kumar
Thankyou... On Fri, Jan 22, 2016 at 12:29 PM, Abhishek Jain wrote: > =PROPER(A1) > > Drag down! > > On Fri, Jan 22, 2016 at 12:18 PM, Vinod Kumar wrote: > >> Dear Team, >> >> Pls. asst. how to change first letter of a word to Cap's, in multiple >>

Re: $$Excel-Macros$$ first letter to be Capital letter

2016-01-21 Thread Abhishek Jain
=PROPER(A1) Drag down! On Fri, Jan 22, 2016 at 12:18 PM, Vinod Kumar wrote: > Dear Team, > > Pls. asst. how to change first letter of a word to Cap's, in multiple cell. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW)