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
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.