B1{=REPLACE(A1,LOOKUP(9,FIND(MID("一二三四五六七八九",ROW($1:$9),1),A1)),1,MATCH(,0/FIND(MID("一二三四五六七八九",ROW($1:$9),1),A1),))
另解=LOOKUP(,0/(FIND(TEXT(ROW($1:$9),"[dbnum1]"),A1)),SUBSTITUTE(A1,TEXT(ROW($1:$9),"[dbnum1]"),ROW($1:$9)))
另解=LOOKUP(,0/FIND(MID("一二三四五六七八九",ROW($1:$9),1),A1),SUBSTITUTE(A1,MID("一二三四五六七八九",ROW($1:$9),1),ROW($1:$9)))
另解 B1 右拉到J1 (J1是結果)=SUBSTITUTE(A1,MID("一二三四五六七八九",COLUMN(A1),1),COLUMN(A1))
留言
張貼留言