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