Trying to organize by numbers in excel

Makoman295  I think there might be a simple solution with lambda or dynamic arrays, here is something that I found online, it works with vba, is going to create a function called "num" that is going to create an index starting from 1 for the range you select. Attached is an example.

https://www.extendoffice.com/documents/excel/3451-excel-sort-numbers-with-text-alpha-text-prefix-suffix.html

Function num(rng As Range) As Integer
Dim n As Integer
For n = 1 To Len(rng)
If Mid(rng, n, 1) Like "[0-9]" Then
num = num & Mid(rng, n, 1)
End If
Next n
End Function