Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-12 Thread dguillett1
e places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - -------- From: Vabz To: excel-macros@googlegroups.com Sent: Wed, September 12, 2012 8:59:52 AM Subject: Re: $$Excel-Macros$$ N

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-12 Thread Paul Schreiner
e places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - ________ From: Vabz To: excel-macros@googlegroups.com Sent: Wed, September 12, 2012 8:59:52 AM Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts hi.

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-12 Thread Vabz
hi.. what i feel is this solution is very complex !! Rgds//Vabz On Tuesday, September 11, 2012 7:09:23 AM UTC+5:30, Asa R. wrote: > > Hi Mangesh, > > I've read your other replies, and as to why you haven't received a formula > method -- most people don't want to take the trouble on a volunteer

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-11 Thread dguillett1
Homework done... Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mangesh Vimay Sent: Tuesday, September 11, 2012 4:56 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts Its really Great Help

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-11 Thread Mangesh Vimay
Its really Great Help Asa !!! Thanks a ton !!! On Tue, Sep 11, 2012 at 7:07 AM, Asa Rossoff wrote: > Hi Mangesh, > > I've read your other replies, and as to why you haven't received a formula > method -- most people don't want to take the trouble on a volunteer basis > to provide a more comp

RE: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-10 Thread Asa Rossoff
Hi Mangesh, I've read your other replies, and as to why you haven't received a formula method -- most people don't want to take the trouble on a volunteer basis to provide a more complex or difficult solution to a given problem when simple solutions exist. Also in business, the simplest solution

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-10 Thread Mangesh Vimay
alf Of *Mangesh Vimay > *Sent:* 10 September 2012 7:55 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need help - To divide the string into > three parts > > ** ** > > Hi Guillett, > > ** ** > > I would like to know all possi

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-10 Thread dguillett1
As I said, I would simply use TTC Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mangesh Vimay Sent: Monday, September 10, 2012 9:24 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts Hi

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-10 Thread Mangesh Vimay
the > file? Unless, of course, this is HOMEWORK > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* Mangesh Vimay > *Sent:* Monday, September 10, 2012 6:11 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Exce

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-10 Thread dguillett1
: $$Excel-Macros$$ Need help - To divide the string into three parts Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar wrote: Dear Mangesh, you can use text to colum Regard

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-10 Thread Mangesh Vimay
Thanks ALL for the Great Help !!! On Mon, Sep 10, 2012 at 5:25 PM, David Grugeon wrote: > In B2 put =LEFT(A2,FIND(",",A2)-1) > In C2 put =MID(A2,LEN(B2)+2,FIND(",",A2,LEN(B2)+2)-LEN(B2)-2) > In d2 put =MID(A2,LEN(B2&C2)+3,99) > > > On 10 September 2012 21:04, Mangesh Vimay wrote: > >> Hi Friend

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-10 Thread David Grugeon
In B2 put =LEFT(A2,FIND(",",A2)-1) In C2 put =MID(A2,LEN(B2)+2,FIND(",",A2,LEN(B2)+2)-LEN(B2)-2) In d2 put =MID(A2,LEN(B2&C2)+3,99) On 10 September 2012 21:04, Mangesh Vimay wrote: > Hi Friends, > > I need your help to divide the string into three parts. > The description and sample is given bel

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-10 Thread Vabz
Hi Mangesh.. PFA.. Cheers Rgds//Vabz On Monday, September 10, 2012 4:41:13 PM UTC+5:30, Mangesh wrote: > > Yes u r right. > I did by using Text to Column option. Its works fine. > But I need it by using formula. > Thanks > > > On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar > > > wrote: > >> Dear

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-10 Thread Mangesh Vimay
Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar wrote: > Dear Mangesh, > > you can use text to colum > > Regard > Manoj > > > On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay wrote: > >> Hi

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-10 Thread Manoj Kumar
Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay wrote: > Hi Friends, > > I need your help to divide the string into three parts. > The description and sample is given below : > [image: Inline image 1] > Waiting for your response. > > Thank