excel排列组合公式问题，求高手解答

好像没有什么公式能实现
SQL或者宏吧 以下是64组

A6B5A4A3B2A1

B1A6B5A4A3B2

C2A6B5A4A3A1

C2B1A6B5A4A3

C3A6B5A4B2A1

C3B1A6B5A4B2

C3C2A6B5A4A1

C3C2B1A6B5A4

B4A6B5A3B2A1

B4B1A6B5A3B2

B4C2A6B5A3A1

B4C2B1A6B5A3

B4C3A6B5B2A1

B4C3B1A6B5B2

B4C3C2A6B5A1

B4C3C2B1A6B5

C5A6A4A3B2A1

C5B1A6A4A3B2

C5C2A6A4A3A1

C5C2B1A6A4A3

C5C3A6A4B2A1

C5C3B1A6A4B2

C5C3C2A6A4A1

C5C3C2B1A6A4

C5B4A6A3B2A1

C5B4B1A6A3B2

C5B4C2A6A3A1

C5B4C2B1A6A3

C5B4C3A6B2A1

C5B4C3B1A6B2

C5B4C3C2A6A1

C5B4C3C2B1A6

C6B5A4A3B2A1

C6B1B5A4A3B2

C6C2B5A4A3A1

C6C2B1B5A4A3

C6C3B5A4B2A1

C6C3B1B5A4B2

C6C3C2B5A4A1

C6C3C2B1B5A4

C6B4B5A3B2A1

C6B4B1B5A3B2

C6B4C2B5A3A1

C6B4C2B1B5A3

C6B4C3B5B2A1

C6B4C3B1B5B2

C6B4C3C2B5A1

C6B4C3C2B1B5

C6C5A4A3B2A1

C6C5B1A4A3B2

C6C5C2A4A3A1

C6C5C2B1A4A3

C6C5C3A4B2A1

C6C5C3B1A4B2

C6C5C3C2A4A1

C6C5C3C2B1A4

C6C5B4A3B2A1

C6C5B4B1A3B2

C6C5B4C2A3A1

C6C5B4C2B1A3

C6C5B4C3B2A1

C6C5B4C3B1B2

C6C5B4C3C2A1

C6C5B4C3C2B1

7个的
C6C5C3B1A4B2

C6C5C3C2A4A1

C6C5C3C2B1A4

C6C5B4A3B2A1

C6C5B4B1A3B2

C6C5B4C2A3A1

C6C5B4C2B1A3

C6C5B4C3B2A1

C6C5B4C3B1B2

C6C5B4C3C2A1

C6C5B4C3C2B1

可用vba来实现
循环！
＝＝＝＝＝＝＝＝＝＝＝
试试吧，但愿能够帮助您！