2013 9:51
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Split with formula
** **
Hi Priti,
** **
Sorry for the late reply., Thanks for the formula provided, really
its a very new things for me and learning tips.
** **
Ok, Can we make in only one
Dear experts,
I want to split the below string into seperate numbers.
Example:
15.00,63.23,18.00
i want into as :
15.00
63.23
18.00
After seperation, i want the min number of those three number. Please
find the attachment for more example
i have use Text to Coloumns, but i want in
PFA sheet solved,
You can split your data by using text to columns wizard and selecting
comma in the options.
One done with this you will data splitted in mutliple columns, now give a
min formula for the beside row, it will give u minimum value, drag it
down till the data is available. Once done,
Thanks Waheed,
Thanks for that, but i dont want to split by text to coloumns, i want
with formulas in one cell.
hope you got my point of query.
Regards,
Chaya
On Thu, May 9, 2013 at 6:26 PM, Shaik Waheed waheedb...@gmail.com wrote:
PFA sheet solved,
You can split your data by using
Hi Chaya,
Pfa
On Thu, May 9, 2013 at 6:30 PM, Chaya chayamon...@gmail.com wrote:
Thanks Waheed,
Thanks for that, but i dont want to split by text to coloumns, i want
with formulas in one cell.
hope you got my point of query.
Regards,
Chaya
On Thu, May 9, 2013 at 6:26 PM, Shaik
Hi Priti,
Sorry for the late reply., Thanks for the formula provided, really its a
very new things for me and learning tips.
Ok, Can we make in only one formula to find the min number in my attached
file earlier ?
Or else can we seperate the number seperately without array formula in your
Hi chaya ,
Yes you can do it.Please see the attached file .
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chaya
Sent: 10 May 2013 9:51
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Split with formula
Hi Priti,
Sorry
[mailto:
excel-macros@googlegroups.com] *On Behalf Of *Chaya
*Sent:* 10 May 2013 9:51
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Split with formula
** **
Hi Priti,
** **
Sorry for the late reply., Thanks for the formula provided, really its
a very new
can do it.Please see the attached file .*
* *
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Chaya
*Sent:* 10 May 2013 9:51
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Split with formula
** **
Hi Priti
] *On Behalf Of *Chaya
*Sent:* 10 May 2013 9:51
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Split with formula
** **
Hi Priti,
** **
Sorry for the late reply., Thanks for the formula provided, really
its a very new things for me and learning tips
10 matches
Mail list logo