Hi,
This is an absolutely inelegant solution to your post, but see whether it
works for you (Excel experts would laugh at this formula)!
To check whether a given string (upto 16 characters) contained in cell A1 is
a palindrome use the following formula:
=A1=MID(A1,16,1)&MID(A1,15,1)&MID(A1,14,1)&MID(A1,13,1)&MID(A1,12,1)&MID(A1,11,1)&MID(A1,10,1)&MID(A1,9,1)&MID(A1,8,1)&MID(A1,7,1)&MID(A1,6,1)&MID(A1,5,1)&MID(A1,4,1)&MID(A1,3,1)&MID(A1,2,1)&MID(A1,1,1)
If the string is a palindrome the formula returns "TRUE", else "FALSE".
Note that the formula doesn't differentiate upper and lower cases. If the
string is a number, start with a ' character.
To reverse a string (upto 16 characters),
remove the "=A1" at the beginning of the formula.
Regards,
B. R. Ramachandran