I have data in a column which looks something like this:
1X3456789 - SEARCH ("X" , A1) = 2
234X73876 - SEARCH ("X" , A2) = 4
839030X38 - SEARCH ("X" , A3) = 7
Is there a way to SEARCH in reverse so it looks from Right to Left ??
1X3456789 - reverseSEARCH ("X" , A1) = 8
234X73876 - reverseSEARCH ("X" , A2) = 6
839030X38 - reverseSEARCH ("X" , A3) = 3
Thank you for any help!
1X3456789 - SEARCH ("X" , A1) = 2
234X73876 - SEARCH ("X" , A2) = 4
839030X38 - SEARCH ("X" , A3) = 7
Is there a way to SEARCH in reverse so it looks from Right to Left ??
1X3456789 - reverseSEARCH ("X" , A1) = 8
234X73876 - reverseSEARCH ("X" , A2) = 6
839030X38 - reverseSEARCH ("X" , A3) = 3
Thank you for any help!