在A列输入公式：
=CHOOSE(B1,"A","B","C","D","E")
下拉填充
字母也可以继续增加不写的时候是空白呢 怎么改=IF(B1="","",CHOOSE(B1,"A","B","C","D","E"))