Sorting within a single cell in Excel

[JARF]

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.

[stanleydgromjr]

JARF,


Welcome to the Excel Forum.


To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

[nimrod]

Please Login or Register  to view this content.

[snb]

But you can also use this function.
Put it in a macromodule.
In de data tot be sorted reside in cell A1, put e.g. in cell B1: =sort_snb(A1)

Please Login or Register  to view this content.

@Nimrod

To populate an array:
Instead of

Please Login or Register  to view this content.

you can use

Please Login or Register  to view this content.