Excel问题:怎么使a,b,c,d变为任意内容后,下方"1234="等后面中的a,b,c,d内容相应的改变？

Question

只是abcd顺序变化，abcd所代表的内容不变。

Answer 1

=SUMPRODUCT(FIND(MID(A1,ROW($1:$4),1),"abcd")*10^(4-ROW($1:$4)))

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"a",1),"b",2),"c",3),"d",4)

两种公式随便选一种就行

理解错你的意思了，你是把数字换成字母用下面这个公式

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,1,"a"),2,"b"),3,"c"),4,"d")

Answer 2

b5填入

“=OFFSET($B$1,LEFT(A5,1)-1,0)&OFFSET($B$1,MID(A5,2,1)-1,0)&OFFSET($B$1,MID(A5,3,1)-1,0)&OFFSET($B$1,RIGHT(A5,1)-1,0)”

其他单元格采用复制此单元格即可

Answer 3

不可以用替换？

Answer 4

请查收，公式=INDIRECT("b"&LEFT(A6))&INDIRECT("b"&MID(A6,2,1))&INDIRECT("b"&MID(A6,3,1))&INDIRECT("b"&RIGHT(A6,1))

Answer 5

最笨的SUBSTITUTE嵌套啊
假设原数据在A列
B1
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"1","a"),"2","b"),"3,"c"),"4","d")
下拉本回答被提问者采纳