You've got Excel skills? Let's see.
It worked out really well last month, so here's the second in the series of Excel challenges. The rules are simple:
Construct a formula to check whether the contents of cell A1 is a palindrome or not; the output from the formula should be either "Palindrome" or "No palindrome". The formula should be case-insensitive, but it must respect punctuation and spaces. The following examples can be used to test your method.
="eye" --> "Palindrome"
="eyes" --> "No palindrome"
="aviva" --> "Palindrome"
="Aviva" --> "Palindrome"
="aibohphobia" --> "Palindrome"
="13631" --> "Palindrome"
="136310" --> "No palindrome"
="Never odd or even" --> "No palindrome"
="step on no pets" --> "Palindrome"
="step on no pet's" --> "No palindrome"
It worked out really well last month, so here's the second in the series of Excel challenges. The rules are simple:
- the submission must solve the stated problem
- the solution must be limited to a single formula (which clearly not CA2-compliant!)
- the shortest formula wins.
Construct a formula to check whether the contents of cell A1 is a palindrome or not; the output from the formula should be either "Palindrome" or "No palindrome". The formula should be case-insensitive, but it must respect punctuation and spaces. The following examples can be used to test your method.
="eye" --> "Palindrome"
="eyes" --> "No palindrome"
="aviva" --> "Palindrome"
="Aviva" --> "Palindrome"
="aibohphobia" --> "Palindrome"
="13631" --> "Palindrome"
="136310" --> "No palindrome"
="Never odd or even" --> "No palindrome"
="step on no pets" --> "Palindrome"
="step on no pet's" --> "No palindrome"
Last edited: