How to order according to comma and bracket?

[london7871]

The VBA below can order according to comma:

Please Login or Register  to view this content.

a,c,e,b,d
to
a,b,c,d,e

How to revise VBA so that it can order within bracket:

a,c(b,c,a),e,b,d
to
a,b,c(a,b,c),d,e

[AlphaFrog]

Will the bracket set always stay with the preceding letter; "c" in your example?

Can there be more than one bracket set?

[london7871]

The bracket will be set with any letter or word and more than one bracket set:

a,c,boy and girl(C-2,c-3,c-1),e,d(2,5,4)
to
a,boy and girl(c-1,C-2,c-3),c,d(2,4,5),e

The aim is to order the words within bracket first;
and then order according to comma.

[Andy Pope]

Here is one way.

Please Login or Register  to view this content.

In your examples you are not doing a case sensitive check. The function has parameters to handle sort order and type of comparison.

[kvsrinivasamurthy]

Try this code

Sub SplitAndJoin()

Please Login or Register  to view this content.

[london7871]

Thanks Andy Pope and kvsrinivasamurthy, both of yours are works.

I have revised kvsrinivasamurthy's VBA so that it can apply to any cells (refer '<<<):

Please Login or Register  to view this content.