excel - 用另一个引用替换列值

Question

我有一个带有分隔值的列，我需要根据参考替换这些值，这是我的请求示例（绿色）

标签： excelreplace

Answer 1

在 B1 中并复制到适合：

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"1","One"),"2","Two"),"3","Three"),"4","Four"),"5","Five"),"6","Six"),"7","Seven"),"8","Eight"),"9","Nine")

（感谢dalakomala完成了大部分的打字工作。）