View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maggie B. Maggie B. is offline
external usenet poster
 
Posts: 1
Default Sorting the contents of a cell

I have a range of cells. Each cell can contain multiple
entries separated by a comma and a space.

Example: cell A2 contains: John, Adam, Charlie

How can I sort the contens of the cell so I get:

A2 = Adam, Charlie, John

Thanks,

Maggie B.