Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread jmothilal
Dear NOORAIN ANSARI sir Thanks for sending function coding. Mothilal.J On Sat, Jun 30, 2012 at 8:35 AM, ╰» ℓαℓιт мσαнη wrote: > Hi, > > Try this also > > =A1&" "&B1&" "&C1 > > Regards, > Lalit Mohan > > > > On Fri, Jun 29, 2012 at 11:29 PM, NOORAIN ANSARI > wrote: > >> Dear Moti Lal, >> >> Yo

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread ╰» ℓαℓιт мσαнη
Hi, Try this also =A1&" "&B1&" "&C1 Regards, Lalit Mohan On Fri, Jun 29, 2012 at 11:29 PM, NOORAIN ANSARI wrote: > Dear Moti Lal, > > You can use below UDF for dynamically > > Function combine_cells(rng As Excel.Range) As String > Dim cell As Excel.Range > For Each cell In rng.Cells > combine

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread NOORAIN ANSARI
Dear Moti Lal, You can use below UDF for dynamically Function combine_cells(rng As Excel.Range) As String Dim cell As Excel.Range For Each cell In rng.Cells combine_cells = combine_cells + CStr(cell.Value) & Chr(10) Next cell End Function see attached sheet -- Thanks & regards, Noorain Ansari w

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread jmothilal
Thanks so much its working . Thanks with Mothilal.J On Fri, Jun 29, 2012 at 9:55 PM, Aditya Tyagi wrote: > > > On Sat, Jun 30, 2012 at 5:21 AM, jmothilal wrote: > >> i am using office 2003, are u send sample worksheet >> Thanks >> Mothilal >> >> >> On Fri, Jun 29, 2012 at 9:46 PM, Aditya Tya

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread Aditya Tyagi
On Sat, Jun 30, 2012 at 5:21 AM, jmothilal wrote: > i am using office 2003, are u send sample worksheet > Thanks > Mothilal > > > On Fri, Jun 29, 2012 at 9:46 PM, Aditya Tyagi wrote: > >> =B1&CHAR(10)&C1 &CHAR(10)&D1 try this >> >> >> On Sat, Jun 30, 2012 at 5:00 AM, ashish koul wrote: >> >>> Su

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread jmothilal
i am using office 2003, are u send sample worksheet Thanks Mothilal On Fri, Jun 29, 2012 at 9:46 PM, Aditya Tyagi wrote: > =B1&CHAR(10)&C1 &CHAR(10)&D1 try this > > > On Sat, Jun 30, 2012 at 5:00 AM, ashish koul wrote: > >> Sub breaktext() >> For i = 1 To Sheets(1).Range("a65356").End(xlUp).Row

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread Aditya Tyagi
=B1&CHAR(10)&C1 &CHAR(10)&D1 try this On Sat, Jun 30, 2012 at 5:00 AM, ashish koul wrote: > Sub breaktext() > For i = 1 To Sheets(1).Range("a65356").End(xlUp).Row > splitdata = Split(Sheets(1).Range("a" & i).Value, Chr(10)) > Sheets(1).Range(Cells(i, 2), Cells(i, 2 + UBound(splitdata))).Value =

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread ashish koul
Sub breaktext() For i = 1 To Sheets(1).Range("a65356").End(xlUp).Row splitdata = Split(Sheets(1).Range("a" & i).Value, Chr(10)) Sheets(1).Range(Cells(i, 2), Cells(i, 2 + UBound(splitdata))).Value = splitdata Next End Sub On Fri, Jun 29, 2012 at 9:21 PM, jmothilal wrote: > > > On Fri, Jun 29, 20

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread jmothilal
On Fri, Jun 29, 2012 at 9:19 PM, ashish koul wrote: > can you attach the sample file > > > On Fri, Jun 29, 2012 at 9:18 PM, jmothilal wrote: > >> Dear any one >> >> I want 3 cell values in 1 cell line by line >> >> Thanks in advance >> >> like >> >> MOTHILAL >> NAVEEN >> RAJA MOTHILAL NAVEEN RA

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

2012-06-29 Thread ashish koul
can you attach the sample file On Fri, Jun 29, 2012 at 9:18 PM, jmothilal wrote: > Dear any one > > I want 3 cell values in 1 cell line by line > > Thanks in advance > > like > > MOTHILAL > NAVEEN > RAJA MOTHILAL NAVEEN RAJA > > -- > > *J.Mothilal : **Universal Computer Systems : # 16, Brindava