How to sort alfabetically
Hello all,
I have this question:
How can I sort alfabetically data that is in one cell with values separated
by commas?
example:
I have one cell with - D, G, A, F, C, B, E,
I need it to be like this - A, B, C, D, E, F, G,
Yes, I could do it manually but this is just an example ;-)
In fact I have dozens of cells with hundreds of values...
Is the a simple way to solve the problem?
I have Excel 2002.
thanks in advance,
--
ccaetano
|