Re: $$Excel-Macros$$ Alternate for concatenate in excel

2014-02-26 Thread Paul Schreiner
February 25, 2014 11:13 AM >Subject: Re: $$Excel-Macros$$ Alternate for concatenate in excel > > > >Hi, > >Any alternate of it. we have nearly 500 rows like this to divide it. > > > > > > >On Tue, Feb 25, 2014 at 8:33 PM, Paul Schreiner wrote: > >

Re: $$Excel-Macros$$ Alternate for concatenate in excel

2014-02-25 Thread santhosh qatester
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:* santhosh qatester > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, F

Re: $$Excel-Macros$$ Alternate for concatenate in excel

2014-02-25 Thread Paul Schreiner
n, 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: santhosh qatester >To: excel-macros@googlegroups.com >Sent:

Re: $$Excel-Macros$$ Alternate for concatenate in excel

2014-02-25 Thread santhosh qatester
an,To all the people > you can,As long as ever you can." - John Wesley* > ----------------- > >*From:* santhosh qatester > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, February 25, 2014 6:12 AM > *Subject:* $$Excel-Macros$$ Alternate fo

Re: $$Excel-Macros$$ Alternate for concatenate in excel

2014-02-25 Thread Paul Schreiner
__ > From: santhosh qatester >To: excel-macros@googlegroups.com >Sent: Tuesday, February 25, 2014 6:12 AM >Subject: $$Excel-Macros$$ Alternate for concatenate in excel > > > >Hi All, > > In excel cell has sql query which has more than 255 characters. > >whic

Re: $$Excel-Macros$$ Alternate for concatenate in excel

2014-02-25 Thread santhosh qatester
Hi Naveen, Thanks for your reply, I have nearly 500 rows, i can't do segregate each one and concatenate that. it has nearly 1000 to 3000 characters each Any alternate solution please let me know. Thanks On Tue, Feb 25, 2014 at 5:29 PM, Naveen Kumar M N < naveenkumarmn...@gmail.com> wrote: >

Re: $$Excel-Macros$$ Alternate for concatenate in excel

2014-02-25 Thread Naveen Kumar M N
Hi, use this formula. =CONCATENATE(C3,TEXT(D3," dd-mmm-"),E3) From Naveen On Tue, Feb 25, 2014 at 4:42 PM, santhosh qatester < santhosh.qat...@gmail.com> wrote: > Hi All, > > In excel cell has sql query which has more than 255 characters. > > which has string+date+string when i use

$$Excel-Macros$$ Alternate for concatenate in excel

2014-02-25 Thread santhosh qatester
Hi All, In excel cell has sql query which has more than 255 characters. which has string+date+string when i use concatenate or & symbol it throws error message can you please let me know there is any alternate for concatenate function in excel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel