That's precisely the point!
Because he's wanting to do this with formulas, he's making the solution more
complex than necessary.
A VBA solution would be very neat and tidy (use split to load an array, and
display the array elements in the cells)
A manual solution using text-to-Columns is also
And, I wonder why he insists.. Homework?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Wednesday, September 12, 2012 8:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three
Its really Great Help Asa !!!
Thanks a ton !!!
On Tue, Sep 11, 2012 at 7:07 AM, Asa Rossoff a...@lovetour.info 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
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
Dear Mangesh,
you can use text to colum
Regard
Manoj
On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:
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
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 kumarmanoj.11...@gmail.comwrote:
Dear Mangesh,
you can use text to colum
Regard
Manoj
On Mon, Sep 10, 2012 at 4:34 PM, Mangesh
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
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(B2C2)+3,99)
On 10 September 2012 21:04, Mangesh Vimay mangesh.da...@gmail.com wrote:
Hi Friends,
I need your help to divide the string into three parts.
The description and
Thanks ALL for the Great Help !!!
On Mon, Sep 10, 2012 at 5:25 PM, David Grugeon da...@grugeon.com.au 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(B2C2)+3,99)
On 10 September 2012 21:04, Mangesh Vimay
Why clutter it up by using UN necessary formulas to clutter up 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:
Hi Guillett,
I would like to know all possible ways of cutting the string into three
parts. So please do needful by suggesting very simple formula for same.
Thanks !!!
On Mon, Sep 10, 2012 at 5:40 PM, dguillett1 dguille...@gmail.com wrote:
Why clutter it up by using UN necessary formulas to
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
Thanks all for their great support to solve this problem.
On Mon, Sep 10, 2012 at 8:27 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Would it be simple for you*
* *
*Function SplitString(rngRange As Range) As Variant*
*SplitString = Split(rngRange.Value, ,)*
*End Function*
* *
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
14 matches
Mail list logo
