Why not just use REPLACE? Select the column containing your list. Hit
CTRL-H. In the FIND WHAT box, type "http://www.microsoft.com/pics/"
and leave the REPLACE WITH box empty. Press REPLACE ALL button. Tada!

All done.


Seth


On Mon, 18 Feb 2008 17:02:01 -0800, forxigan
wrote:

I have excel workbook which contains column of cells with web adresses(as
text, not hyperlinks), which lead to *.jpg files.
All the web links have the exact same adress, except the jpg filename,
for example: http://www.microsoft.com/pics/1.jpg,
http://www.microsoft.com/pics/2.jpg and so on.

Is there a possibility to rename multiple cells by pattern and remove all
text, except the actual filenames(1.jpg, 2.jpg..)?

Thx in advance.