Natural Sort cell contents

Can anyone suggest a sub-routine or procedure to naturally sort cell contents? For example, if a cell contains "TP15, TP5, TP1, TP10" my current sort routine produces "TP1, TP10, TP15, TP5". I would like the output to show "TP1, TP5, TP10, TP15" Any suggestions?

Here's a somewhat kludgy way. The function separates the string part from the number part. It will work if the number part is at the end of the string. What you do is get the number part in one cell and remove it from the string part in another then do a multi-level sort.

Thanks dflak. I will give it a try.

Originally Posted by Gandalf2524

For example, if a cell contains "TP15, TP5, TP1, TP10" my current sort routine produces "TP1, TP10, TP15, TP5". I would like the output to show "TP1, TP5, TP10, TP15" Any suggestions?

UDF

Use in cell like
=SortCell(A1,", ")

Please Login or Register  to view this content.