Need to Sort String of Letters in Cell

[rwmill9716]

C column has cells filled with letters beginning in Cell C8. Each of these is combined with the letter combination in Cell D7 (e.g., C9&D$7) to form the combinations beginning in Cell D9 and following below in Col D. I need to sort those letters within each cell into Col E, then eliminate the letters that appear twice (Max possible) and place the remaining in Col F.

<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">7</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;">Design Generators</td><td style="text-align: center;border-top: 1px solid black;;">ABD</td><td style="text-align: center;border-top: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: center;border-left: 1px solid black;;">ABD</td><td style="text-align: center;background-color: #000000;;"></td><td style="text-align: center;;"></td><td style="text-align: center;border-right: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: center;border-left: 1px solid black;;">ACE</td><td style="text-align: center;;">ABDACE</td><td style="text-align: center;;">AABCDE</td><td style="text-align: center;border-right: 1px solid black;;">BCDE</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: center;border-left: 1px solid black;;">BCF</td><td style="text-align: center;;">ABDBCF</td><td style="text-align: center;;">ABBCDF</td><td style="text-align: center;border-right: 1px solid black;;">ACDF</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">ABCG</td><td style="text-align: center;border-bottom: 1px solid black;;">ABDABCG</td><td style="text-align: center;border-bottom: 1px solid black;;">AABBCDG</td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;;">CDG</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />

Thanks for your help.

Ric

 

[rwmill9716]

Thanks, Rick. This does exactly what I was looking for.

ric

 

[shg]

StrSort(A1) sorts the string into B1, but StrSort(B1) doesn't eliminate double letters; it just resorts B1.

Did you miss http://www.mrexcel.com/forum/showpost.php?p=2844413&postcount=4?