请问如何在wps表格中,在一行或一列中不同的字前面加上不同样的字?

Question

如题所述

Answer 1

在B2单元格输入公式：
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"不知道","A"),"知道","B"),"不是","C"),"是","3是"),"A","0不知道"),"B","1知道"),"C","4不是")
复制并下拉，即可。追问

大神，可以发下给我复制吗

谢谢！