Hello,
I would like to ask that how is it possible to sort (ascending) the values within cell with vba, the values separeted by comma ",".
For instance: A1 = 4, 5, 1, 3, 2
Thanks in advance the reply!
Hello,
I would like to ask that how is it possible to sort (ascending) the values within cell with vba, the values separeted by comma ",".
For instance: A1 = 4, 5, 1, 3, 2
Thanks in advance the reply!
Check out the attachment. I coded up a worksheet function you could use to do this.
=sortWithinCell(Cell_With_List,",",1) -> that will produce an ascending list (like 1,2,3,4,5)
=sortWithinCell(Cell_With_List,",",ANY OTHER INTEGER) -> that will produce a descending list (like 5,4,3,2,1)
Please Login or Register to view this content.
Last edited by GeneralDisarray; 07-03-2014 at 09:39 AM. Reason: Removed annoying trailing 0 value
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
hi Villalobos, option, please check attachment, press Run button or run code "test
Hello GeneralDisarray and watersev,
Your solutions are perfect, I would like to say thank you for the help!
Thank you, glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks