Below is a possible solution to the Challenge 57 – Another Word Challenge – Palindrome or Not
Use the below formula –
=IF(SUMPRODUCT(–(MID(SUBSTITUTE(A1," ",""),ROW(INDIRECT("1:"&LEN(
SUBSTITUTE(A1," ","")))),1)=MID(SUBSTITUTE(A1," ",""),LEN(SUBSTITUTE(
A1," ",""))+1-ROW(INDIRECT("1:"&LEN(SUBSTITUTE(A1," ","")))),1)))=LEN(
SUBSTITUTE(A1," ","")),"Palindrome","Not Palindrome")