| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i find palindromes using excel?
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(A 1,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 "yan" wrote: how do i find palindromes using excel? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| How do I find items common to two columns in Excel? | Excel Discussion (Misc queries) | |||
| How do I find items common to two columns in Excel? | Excel Discussion (Misc queries) | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
| Linking Excel files -- I cannot find an answer anywhere. | Excel Discussion (Misc queries) | |||
Threaded Mode
