excel - Excel公式在单元格末尾有条件地替换

Question

尝试对数据集中仅以“A”结尾的单元格进行大规模替换。这不断出现价值错误

=IF(RIGHT(A1,2)="A",REPLACE("A", RIGHT(A1, 1),2, "Away"), "未识别")

标签： excelexcel-formula

Answer 1

跳过替换：

=IF(RIGHT(A1,2)=" A", A1 & "way", "not recognized")

如果你真的想使用它：

=IF(RIGHT(A1,2)=" A",REPLACE(A1,LEN(A1)-1,2," Away"), "not recognized")