In a helper column enter:

=SUBSTITUTE(A1,"http://www.microsoft.com/pics/","")

then copy the helper column and paste/special/value back onto the original
column
--
Gary''s Student - gsnu200769


"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.