I'm hoping there's a way to do this that's simpler than the brute-force method I'm doing now. I haven't come up with a good way to do a macro and while I have some minimal Visual Basic skills, I'm still trying to figure out how to use the editor in Excel and access modules from the workbook. So, I'm hoping someone else has needed to do something similiar so I can avoid reinventing the wheel.

One column of my spreadsheet contains cells that each contain a list of text phrases separated by commas. These phrases need to be alphabetized. (Example text: Nives Temprano, Nieves Temprano, Albillo Temprano, Acerba, Acerva, Besto Maduro, Blanco Ribera, Albillo de Cebreros) Since these aren't just single words to alphabetize, it complicates things. The alphabetized list of the example above would look like this: Acerba, Acerva, Albillo de Cebreros, Albillo Temprano, Besto Maduro, Blanco Ribera, Nieves Temprano, Nives Temprano. Working in Excel 2002 on Windows XP.

email at trpinkelton at ucdavis d.o.t edu