Hello all,

I was wondering how difficult it would be to sort comma delimited values within a single cell in Excel 2010. Say I've got a single cell containing this:

BA102, BA15, BA25, BA17, BA27

What I'm looking for is a macro or function that would change the cell contents to this:

BA15, BA17, BA25, BA27, BA102

I realize that it could easily be done in someones head while they're looking at it, but the cells I'm working with are filled with hundreds of these little values and the spreadsheets are created by another company and given to us all out of order like in that first line of values up there.

3 cheers to my boss for handing this task off to an accountant. We don't have an in-house programmer I can implement a macro, I just don't know how to write them, heh. Is there any way to do this in a relatively easy way?

Thanks for any help anyone can give me, I appreciate it. If more info is needed I'll be happy to provide it.