不计空格首先将单元格中的空格全去掉，再用if函数判断if(SUBSTITUTE(单元格A," ","")=SUBSTITUTE(单元格B," ",""),"一致","不一致")
=EXACT(SUBSTITUTE(A1," ",""),SUBSTITUTE(A2," ",""))a1,a2为比较的单元格
=if(a1=b1,"一致","不一致")
