Re: Get FileExtension when ><3 caracters
If I understand correctly you just want to isolate the extension of the file and this is tricky as it could be 2,3 or 4 characters.
Why dont you just use INSTRREV function to search for a "."
The INSTRREV function searches from the end of the string and so when it finds the first period (".") you should be able to isolate the last characters of the string based on the position of the period and the length of the string.
God I hope that makes sense :?