View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ccaetano ccaetano is offline
external usenet poster
 
Posts: 1
Default 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