How to Get Position Of Last Occurrence of Symbol In Microsoft Excel
If you want to know the position of a symbol in Excel then you should read this article. In this article, we will learn how to find position of last occurrence of certain character.
Question): How can I find the position of the last occurrence of a symbol?
Example: If a cell contains website address then it will have multiple (.) dots & in this scenario, we need a formula to return the position of the last dot.
Following is the snapshot of data we have; now we need a formula to extract the position of the last dot (not the position of first dot)
In case you have a similar requirement & the specific symbol or character is different i.e. other than dot then in that case, you are required to simply replace the dot with your special character.
In this way, we can retrieve position of the last occurrence of a specific symbol.
Download - how to get position of last occurrence of symbol - xlsm
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.