Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-07-2019, 08:39 PM
14spar15 14spar15 is offline Put numbers within a cell into numerical order. Windows 7 64bit Put numbers within a cell into numerical order. Office 2010 64bit
Competent Performer
Put numbers within a cell into numerical order.
 
Join Date: Mar 2011
Posts: 100
14spar15 is on a distinguished road
Default Is this the right direction?

I found this but it puts each individual digit in order and without spaces. Could it maybe be modified? The string will always consist of 4 digit numbers (Years). Even if each group of four digits could be grouped together and sorted without spaces I could maybe add spaces after sorting. Thanks

Private Function SortCharacters(theString As String) As String
Dim currentChar As String
Dim sourceNum As Integer
Dim destNum As Integer
For sourceNum = 1 To Len(theString)
currentChar = Mid(theString, sourceNum, 1)
If sourceNum = 1 Then
SortCharacters = currentChar
Else
destNum = 1
While destNum <= Len(SortCharacters) And currentChar > Mid(SortCharacters, destNum, 1)
destNum = destNum + 1
Wend
SortCharacters = Left(SortCharacters, destNum - 1) & currentChar & Mid(SortCharacters, destNum)
End If
Next sourceNum
End Function
Private Function SortCharacters(theString As String) As String
Dim currentChar As String
Dim sourceNum As Integer
Dim destNum As Integer
For sourceNum = 1 To Len(theString)
currentChar = Mid(theString, sourceNum, 1)
If sourceNum = 1 Then
SortCharacters = currentChar
Else
destNum = 1
While destNum <= Len(SortCharacters) And currentChar > Mid(SortCharacters, destNum, 1)
destNum = destNum + 1
Wend
SortCharacters = Left(SortCharacters, destNum - 1) & currentChar & Mid(SortCharacters, destNum)
End If
Next sourceNum
End Function
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort numbers in Ascending order btserver Excel 5 03-16-2019 07:54 AM
Put numbers within a cell into numerical order. Why isn't cross-references dialogue box in numerical order? seanspotatobusiness Word 1 07-26-2018 03:05 PM
How do I Update Caption Numbers appear in Sequential Order TechDiva95 Word 10 02-24-2018 10:06 AM
Put numbers within a cell into numerical order. Placing order numbers on worksheets Edward 012345 Word 2 10-19-2016 03:13 PM
Plotting Numerical and Non-numerical Data Set Ife Excel 0 04-23-2012 10:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft