View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default how do i find palindromes using excel?

Find where? Are you asking if you can test if a string is a palindrome?
Or do you want to reverse a number, if the latter with the number in A1 use

=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))*10^(ROW(IN DIRECT("1:"&
LEN(A1)))-1))

--

Regards,

Peo Sjoblom


"yan" wrote in message
...
how do i find palindromes using excel?