changing text in multiple cells by pattern

[forxigan]

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.

 

[Gary''s Student]

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

 

[Maxwell]

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

 

[forxigan]

thx for the solution

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

 

[forxigan]

thx for the solution

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