Function or formula to identify the last repeated character in a cell in Excell
Posted on 2016-10-24
We have a list of files in an excel and want to separate their file extension. We are using a combination of commands like search(), len(), left(), right(). However some files has various periods in their name (for example, file.of.mine.txt), thus making it difficult to set the 3 character of the extension. So we thought if we can identify the last period we can calculate the exact 3 or 2 or 5 extension that a file may have (for example, filename.text or filename.manifext).