<div>
Man, you make it look oh so simple.
</div>


<div>
<div class="content wysiwyg-content">
I want the text from some point on to the right end to show.<br />
I have a cell that has the following text in it.<br />
<br />
<a href="http://www.somewebsite.com/somefolder/somefile/thisfile032154.xls" rel="ugc">http://www.somewebsite.com/somefolder/somefile/thisfile032154.xls</a><br />
<a href="http://www.somewebsite.com/somefolder/somefile/thisfile032asdf154.xls" rel="ugc">http://www.somewebsite.com/somefolder/somefile/thisfile032asdf154.xls</a><br />
<a href="http://www.somewebsite.com/somefolder/somefile/thisfile032154.da.xls" rel="ugc">http://www.somewebsite.com/somefolder/somefile/thisfile032154.da.xls</a><br />
....<br />
<br />
I want to cut the filename out of each and put it in a column to the right.<br />
I've been struggling to get the =RIGHT() function to do this, but since the filename length is constantly changing I can't seem to get it.<br />
<br />
Any ideas.<br />
thanks<br />
david
</div>
</div>


I want the text from some point on to the right end to show.
I have a cell that has the following text in it.

http://www.somewebsite.com/somefolder/somefile/thisfile032154.xls
http://www.somewebsite.com/somefolder/somefile/thisfile032asdf154.xls
http://www.somewebsite.com/somefolder/somefile/thisfile032154.da.xls
....

I want to cut the filename out of each and put it in a column to the right.
I've been struggling to get the =RIGHT() function to do this, but since the filename length is constantly changing I can't seem to get it.

Any ideas.
thanks
david

Extract filename from a full path in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.