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 >> cell. >> >> -- >> Are you =EXP(E:RT) or =NOT(EX

Re: $$Excel-Macros$$ Re: Pivot Sorting

2016-01-21 Thread Satendra kumar
Hi Mandeep, find the attachment.. thanks satendra kumar On Fri, Jan 22, 2016 at 12:39 PM, Mandeep Baluja wrote: > PFA !! thread closed !!! > > > Regards, > Mandeep baluja > https://www.linkedin.com/messaging/thread/6086488646137958400 > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A

$$Excel-Macros$$ Re: Pivot Sorting

2016-01-21 Thread Mandeep Baluja
> > PFA !! thread closed !!! Regards, Mandeep baluja https://www.linkedin.com/messaging/thread/6086488646137958400 -- 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/discu

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) ! Join official Faceb

$$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 conci

Re: $$Excel-Macros$$ Find and Replace with Bold

2016-01-21 Thread Vinod Kumar
Thankyou.. On Thu, Jan 21, 2016 at 6:21 PM, Paul Schreiner wrote: > Are you wanting a VBA solution? > If so, have you tried recording a macro and DO it? > > If you're asking how to DO it: > simply edit the cell, highlight the word, then select "Bold" from the icon > (or ctrl-B) > > If you were t

$$Excel-Macros$$ Re: Find and Replace with Bold

2016-01-21 Thread Mandeep Baluja
> > check Two scenarios given in different sheets and let me know !! >> > Sub MakeBold() Dim nrows As Long: nrows = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row With ActiveSheet For nrow = 2 To nrows Searchstring = .Range("A" & nrow).Value searchchar = .Range("B" & nrow).Value

Re: $$Excel-Macros$$

2016-01-21 Thread SUDHIR VERMA
On 20 January 2016 at 23:51, SUDHIR VERMA wrote: > Dear All, > > I need a macro to perform for sending hundreds of mail saved already in > drafts. > > Please try if it will work on selected mails of draft. > > Thanking You > > Sudhir > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Re: Search specific text or numbers in excel folder

2016-01-21 Thread amar takale
Dear Mandeep Sir Wow. Perfect,You are done it……… I am really thankful for its wonderful VBA Coding. Sorry for late reply due to heavy workload. It's Great output for this Group. Regards Amar On Tue, Jan 19, 2016 at 4:51 PM, Mandeep Baluja wrote: > Check this out and let me know !!

$$Excel-Macros$$ Client in Irving, TX need 3 JD Edwards (JDE) Developers with EnterpriseOne

2016-01-21 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Job Title: JD Edwards (JDE) Developers* *Location: Irving, TX* *Duration: 3+ months* The selected hire will be responsible for researching, analyzing, designing, documenting and implementing JD Edwards ap

$$Excel-Macros$$ Client in Woodlands, TX need Senior Informatica Admin/ Developer with SAP Connectors

2016-01-21 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title : Senior Informatica Admin/ Developer with SAP Connectors* *Expected Duration: 6+ months* *Location: The Woodlands, TX (north of Houston)* *Interview:* Face-to-face so candidates must be within sho

$$Excel-Macros$$ Pivot Sorting

2016-01-21 Thread Chandra Shekar
Hello, Could you please help in sorting pivot based on month? Thanks in advance Regards, Chandru -- 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

Re: $$Excel-Macros$$ Find and Replace with Bold

2016-01-21 Thread Paul Schreiner
Are you wanting a VBA solution?If so, have you tried recording a macro and DO it? If you're asking how to DO it:simply edit the cell, highlight the word, then  select "Bold" from the icon (or ctrl-B) If you were to record a macro for this, you'll find that VBA utilizes a  Characters() function.Let

$$Excel-Macros$$ Re: Find and Replace with Bold

2016-01-21 Thread Vinod Kumar
Pls. find the sample file in required format On Thursday, January 21, 2016 at 3:11:58 PM UTC+5:30, Vinod Kumar wrote: > > Dear Team, > > pls asst. how to *BOLD *single word, whn there is multiple words in > single cell. > > but the words are in different cell, any option thru find and replace. >

$$Excel-Macros$$ Re: Find and Replace with Bold

2016-01-21 Thread Mandeep Baluja
> > *What are the parameters/criteria to do the bold,Give us output format > required and list of words that need to be bold by giving example in Excels > sheet.* > Regards, Mandeep baluja -- 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) ! J

$$Excel-Macros$$ Find and Replace with Bold

2016-01-21 Thread Vinod Kumar
Dear Team, pls asst. how to *BOLD *single word, whn there is multiple words in single cell. but the words are in different cell, any option thru find and replace. Thanks in advance. -- 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 offic