How to order members of all cells in a column alphabetically?

[wali]

Hello,

i want to order the members of all cells in a column alphabetically. The members in the cell are seperated with ";"

before:
Col.D
Mellon;Berry;Aapp;Orange;Apple
Z;Y;F;B;O;L;M;A


After:
Col.D
Aapp;Apple;Berry;Mellon;Orange
A;B;F;L;M;O;Y;Z

Thanks for each help in advance.

[gurusanthanam]

This involves series of steps according to me...

so i have attached an excel sheet based on your example....

Hope this helps u

[wali]

Dear gurusanthanam,
thank you very much for your answer. The problem is that i have one column containing 150 000 cells. And that would creat a mess if i try to do these steps.

If some one has a mcro for this problem that would be cool.

[shg]

Try this:

Please Login or Register  to view this content.

[wali]

Dear SHG,

than you very much. It is really cool. Its working and solved my problem. thanks alot. U are great

[shg]

You're welcome, wali, glad it worked for you.