How to sort alfabetically

[Guest]

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,

 

[Guest]

You can do the following:
Separate the data of cell by comma (Data/Text to columns) and after this
sort by row.
Not a simle way, but the first i had in mind.