Question

excel中如何将四个“|”替换成ABCD

Answer 1

你好！
如果单元A1为“|456”，B1为“|381”，C1为“|581”，D1为“|无正确答案”，那么你只需要在
E1输入="A"&mid(A1,2,50)
F1输入="B"&mid(B1,2,50)
G1输入="C"&mid(C1,2,50)
H1输入="D"&mid(D1,2,50)
向下填充即可
如有疑问，请追问。

Answer 2

假设答案在A1单元格，形式为：|123|234|345|3456，则公式为：
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"|","A、",1),"|","
B、",1),"|","
C、",1),"|","
D、")
如形式为：123|234|345|3456，则公式为：
="A、"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"|","
B、",1),"|","
C、",1),"|","
D、")
如为其他形式，类推。