Sort text that is deliminated within a cell
Hi Mark,
You could use 'Text to Columns' delimited option to put your
data into separate cells then sort the cells the way you want
and then recombine the data to a single cell by concatenating.
e.g.
original data in A1
Use text to columns
Data is now in cells A1,B1,C1,D1,E1,F1
Now sort your data how you wish.
Then in G1 put this formula
=A1&", "&B1&", "&C1&", "&D1&", "&E1&", "&F1
Now select columns A1 to F1 (entire columns) and delete them
Your data will now be sorted and back in place in cell A1.
HTH
Martin
|