Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Prafull Jadhav
> >>> On Fri, May 10, 2013 at 10:17 AM, Priti_verma >>> wrote: >>> >>>> *Hi chaya ,* >>>> >>>> *Yes you can do it.Please see the attached file .* >>>> >>>> * * >>>> >>>> * * >>>>

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
*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 >>> *

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread priti verma
iti_verma wrote: > >> *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:*

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
groups.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 for the late reply.,

RE: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Priti_verma
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 for

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
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 a

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread priti verma
Hi Chaya, Pfa On Thu, May 9, 2013 at 6:30 PM, Chaya 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 Waheed

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
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 wrote: > PFA sheet solved, > You can split your data by using "text to columns" wi

Re: $$Excel-Macros$$ Split with formula

2013-05-09 Thread Shaik Waheed
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

$$Excel-Macros$$ Split with formula

2013-05-09 Thread Chaya
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 formu