I would like to sort the contents of a cell alphabetically. My data consists of both alpha and numeric values, and is comma delimited.

For example, given values TP6, TP88, TP683, SH2, SH25, SH214; I would like the output to read SH2, SH25, SH214, TP6, TP88, TP683. Note, the 3 SHxx values are not how Excel would normally sort them.

Any thoughts?

Thanks
Gandalf2524