在Excel中,如何将一个数字的头位改成字母?答:=REPLACE(A1,1,1,CHOOSE(LEFT(A1,1),"B","A","C","D","E","F","G","H","I"))A,B,C,D,E自己根据需要改,对应1-9
EXCEL如何将数字1~20换成字母a~t答:VLOOKUP hlookup等可以。=HLOOKUP(A1,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20;"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T"},2,0)或 =CHAR(64+A1)根据你实际情况运用 ...