Fwd: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

.pj <http://www.facebook.com/dude.pj>* *We meet for a reason, either you're a blessing or a lesson...* -- Forwarded message -- From: Devendra Sahay <devendrasahanypt...@gmail.com> Date: Fri, Jan 15, 2016 at 2:35 PM Subject: Re: $$Excel-Macros$$ Sorting Comma Separated Values

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hey Devendra, This code made me insane :*0,Let me tell you why ?? 1) Numerous of Keywords Integers,Y,Years,SR Doesn't understood the meaning what they are denoting Except years. 2) Took(Almost 2.5 hour). Sorting is easy when all are numbers but difficult when Text values !! the previous code

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Thanks Pankaj & Mandeep, all the codes running properly on real time data. On Fri, Jan 15, 2016 at 7:10 PM, Pankaj Sharma wrote: > Result type2 is here: > > > Sub SortRangeData2() > > Dim sh1 As Worksheet, sh2 As Worksheet > Dim rng1 As Range, rng2 As Range,

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Result type2 is here: Sub SortRangeData2() Dim sh1 As Worksheet, sh2 As Worksheet Dim rng1 As Range, rng2 As Range, rng As Range, data As Range Dim arr As Variant, arr2 As String, txt As String Dim i As Long, lr As Long Set sh1 = ActiveSheet On Error Resume Next Set

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi Mandeep, Please revert, as I am facing a big issue because of this. Thanks On Fri, Jan 15, 2016 at 11:33 AM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Mandeep, > > Please revert. > > > On Thu, Jan 14, 2016 at 5:37 PM, Devendra Sahay < > devendrasahanypt...@gmail.com>

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

> > Didn't get what is ref.name ??? Didn't find it anywhere in your data,Will > it be possible if you share the output required format. > Regards, Mandeep baluja -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hey Devendra, Asked for output format? your query is not understandable. data shuffled all the data ??, Show me the output you require for this data given below :- Col 1Col 2 A10,8year,5 year,15 B15,20year,17 D30,50 year,12 -- Are you

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi, I dont want to sort column a, I want to sort the comma separated data alphabetically & numerically in column 2. but the code which i have shared, it shorts the data of column a & b both, So all the data shuffled This is the required format of the data. Col 1Col 2 A

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi Mandeep, Please revert. On Thu, Jan 14, 2016 at 5:37 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi, > > I dont want to sort column a, I want to sort the comma separated data > alphabetically & numerically in column 2. > > but the code which i have shared, it shorts the

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi, Sample of the data is attached. Please check ​. Thanks, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

$$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi Experts, Currently I am using below code to sort comma separated values within a cell but In case I have to sort these value with their respective ref. name. this code sorts the values & the ref. name alphabetically & data shuffled all the data, So because of this am unable to reconcile the