There are times when one wants to extract the last part of a string, say the file name from a string that contains the filename including the path. This short note describes a few ways to do that.
The example we will use is the following. Cell A1 contains the value c:\x\yz.jpg. What [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2011/07/14/extract-the-last-token-in-a-cell/
Posted
Jul 14 2011, 03:17 AM
by
Daily Dose of Excel