Sort Mulple Values alphabetically within a Cell seperated by a comma

[lesoies]

I have a macro that can sort multiple values in one cell seperated by a comma alphabetically (see attached). The only problem I have with it is if you select multiple cells within a column (or the entire column) it only sorts the first cell and not all cells within the selection. Can the macro be modified to sort all cells that are part of the selection? Thx.

[kalak]

maybe alter as in red

Please Login or Register  to view this content.

[lesoies]

Excellent. Thanks kalak..

[pszpeti]

Hi! How do i make it work on any cell in a document? Or every cell in a document for that matter... I have a huge pile of data, double letter columns, 700+ rows. I desperately need this macro to work. Please help!

[kalak]

Hi,

This thread is marked as solved, so probably not many on the forum would look at it further.

Suggest that you start a new thread, stating your problem and providing some sample data for your problem showing just what you want done with it.

Posting a sample worksheet is easy enough. Check the FAQ.

Personally I'm not doing that sort of stuff now, but somebody else may be interested in looking at it.

[pszpeti]

Oh OK! Thx, kalak!