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
a multi-cell array formula over the selected cells. > > · Copy the array-entered range from row 2 (e.g. B2:D2) to every > other row in your table. > > > > Hope this is of interest, > > Asa > > > > > > *From:* excel-...@googlegroups.com [m

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
> **·**Then hit *F2* (edit cell) and *Ctrl-Shift-Enter* (confirm > array formula). This confirms a multi-cell array formula over the selected > cells. > > **· **Copy the array-entered range from row 2 (e.g. B2:D2) to > every other row in your table. > > *

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

2012-09-10 Thread Asa Rossoff
Vimay Sent: Monday, September 10, 2012 4:04 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help - To divide the string into three parts Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : Inline image 1 Waiting

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

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

2012-09-10 Thread Mangesh Vimay
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. Thanks. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM R