Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-08-21 Thread De Premor
Another simple and short =TRIM(RIGHT(SUBSTITUTE(A2,",",REPT(" ",99)),99)) Pada 21/08/2013 16:12, Andrew Mangozho menulis: Another simpler but rather long method to get the same result On Tue, Jul 30, 2013 at 4:31 AM, Waseem Saifi > wrote: Dear Rajkumar,

Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-08-21 Thread Andrew Mangozho
Yes, thats great and faster. On Wed, Aug 21, 2013 at 2:36 AM, अनिल नारायण गवली wrote: > Dear Rajkumar, > > > U can use text to columns option . > click on comma checkbox and finish it. > > Warm Regads, > Gawli Anil > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software

Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-08-21 Thread अनिल नारायण गवली
Dear Rajkumar, U can use text to columns option . click on comma checkbox and finish it. Warm Regads, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Aug 21, 2013 at 2:42 PM, Andrew Mangozho wrote: > Another simpler but rather long

Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-08-21 Thread Andrew Mangozho
Another simpler but rather long method to get the same result On Tue, Jul 30, 2013 at 4:31 AM, Waseem Saifi wrote: > Dear Rajkumar, > > Please find attached file with solution. > > Regards, > Waseem Saifi > > > On Tue, Jul 30, 2013 at 3:48 PM, Raj Kumar wrote: > >> Dear Group, >> >> We have lo

Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-07-30 Thread Waseem Saifi
Dear Rajkumar, Please find attached file with solution. Regards, Waseem Saifi On Tue, Jul 30, 2013 at 3:48 PM, Raj Kumar wrote: > Dear Group, > > We have lots of records and Segregate the data based on only last comma > and consider the same > > Like, > *Data

$$Excel-Macros$$ How to split Data based on last comm,

2013-07-30 Thread Raj Kumar
Dear Group, We have lots of records and Segregate the data based on only last comma andconsider the same Like, *Data Result Shold be* Raj, Kumar, Bharti Bharti Sadan, Kumar, SinhaSinha Madan, Kuma