Dear All,

Please help in the following...

i have 2 columns each on have string values separated by commas
example:

columns 1

O9,L2,A2,7E,IT2
A2,C6,HY,IK,O9,CHE,MCP
IK,3D,HY,A8,P0,IY
7E,HY,O9,IT2,L2


columns 2
P0,L2,IT2,7E,3D
A2,HY,L2,IK,O9,CHE,MCP
IK,IT2,HY,A8,7E,O9
O9,C6,IY,A2,HY

I need to create a button to run a macro to create the 3rd column of Common string. The cells under the Common String column must contain the common codes from the first 2 columns and must be separated by comma in alphabetical order.

Please anyone can you help.

Regards