String - Condense or Expand

You need to attach an example workbook

That's an image not a workbook

Hello jonny,

Quite an interesting question ...

Do you currently have a draft UDF you could post ... or should this UDF be built from scratch ...

Hello again,

Drafted an initial UDF ...

Function mySplit(rng As Range)
    Dim myArray, temp
    Dim i As Integer, j As Integer
    
    ' Split string into Array
    myArray = Split(rng.Value, ", ")
    ' Sort Array from A to Z
        For i = LBound(myArray) To UBound(myArray)
            For j = i + 1 To UBound(myArray)
                If UCase(myArray(i)) > UCase(myArray(j)) Then
                    temp = myArray(j)
                    myArray(j) = myArray(i)
                    myArray(i) = temp
                End If
            Next j
        Next i
    ' Display Result
    mySplit = Join(myArray, ", ")
End Function

Hope this will help

Thanks for your feedback ...

Hello jonny,

Thanks for your feedback ...

Have not started working on the grouping ...

My question was : Do you currently have a draft UDF you could post ... or should this UDF be completely built from scratch ...

OK ... Thanks ...

It is a bit of a challenge ... since there are quite a number of different steps to cover ...

Extract prefix, Split, Sort, Group, Insert dashes, Join ... and Clean

So this will require some time and efforts ...

Hello jonny,

Regarding your UDF to get the bins location in a short form ...

attached is your test file ... BUT now ... I have to get myself some more aspirin

Hope this will help

Once you have had a chance to test the UDF ... feel free to share your comments ...

Hi Jonny,

Glad to hear this could help you out ...

Thanks a lot for your very kind words ...

MANY MANY THANKS ... for your Avalanche of THANKS ...

To Future Forum Readers

By coincidence, just stumbled upon the Exact Reverse situation with a blog post designed by Smallman

with UDF called Sequence :

Create Number Sequence with VBA Custom Function — Excel Dashboards VBA

An Excel custom function that allows sequental number sequences to be created.

www.thesmallman.com

for example: How to list all numbers between : 100-117

Hope this could assist