最后数字替换與插入 (10930)

F2=REPLACE(D2,LEN(LOOKUP(9^9,LEFT(D2,ROW($1:$9))*1)),1,"A")

G2=REPLACE(D2,LEN(LOOKUP(9^9,LEFT(D2,ROW($1:$9))*1))+1,,"A")

簡體字 有誤 G2=REPLACE(D2,2*LEN(D2)-LENB(D2),1,"A")