This does the trick:
=1*(A1=CONCAT(MID(A1,LEN(A1)-SEQUENCE(1,LEN(A1),0),1)))
It reads the string in a cell backwards using MID
and SEQUENCE
, and compares the CONCAT
result with the original to see if it is the same, i.e. the string is symmetric.
Multiplying by 1
forces the Boolean into an integer.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…