Hi,
Need your help to make a macro wich it's going to sort comma delimited number in the correct order..
see attached file to get the wanted reult..
Thanks in advance...
Hi,
Need your help to make a macro wich it's going to sort comma delimited number in the correct order..
see attached file to get the wanted reult..
Thanks in advance...
I have no idea how to answer this, but looking at your data, I have to ask...
from this...
,10,11,12,13
how on earth do you get this???
,2,3,4
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I think that what the OP wants is not to sort the numbers in the string, but to sort the strings according to the first number in the string.
Using Excel's sorting ",11,12,13" < ",2,3,4" which the OP doesn't want.
I think this will do it. If there is a bunch of data, this bubble sort will be slow and if the data is fouled, the LT function will have to clean it up.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hello,
Mike
thanks for your code, it does work but it's there a way to move the entire row as the numbers get in the correct order..
Perhaps
Please Login or Register to view this content.
Mike,
Thanks for your help!!
It works perfect...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks