Sort values within a cell in Excel 2007

[asparak]

Hi,

I'm trying to sort some values within a cell, but none of the built in functions available to me seem to do it. Unfortunately I'm not allowed to use the MoreFunc Add-on on our system as I understand that might be able to do it.

The Cell will contain a series of alphanumeric values, separated by comma and a space:

ABC001.002, ABC002.019, ABC002.010, ABC001.001 etc

Is there an easy way to get them to sort automatically so the cell becomes:

ABC001.001, ABC001.002, ABC002.010, ABC002.019

This only needs to happen in one column of my spreadsheet (Column P) and work dynamically across 1700 rows so far, so each time colum P of a row gets updated.

Any ideas would be gratefully accepted.

Thanks

Richard

[JosephP]

I reckon this UDF oughta do it

Please Login or Register  to view this content.

in a cell: =SortList(A1)

[jindon]

Try

Please Login or Register  to view this content.

[asparak]

Thanks. I'll try those two methods when I get back to work later.

[asparak]

Works perfectly. Thanks very much for the help