changing text in multiple cells by pattern
 

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.

changing text in multiple cells by pattern
 

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.

changing text in multiple cells by pattern
 

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.

changing text in multiple cells by pattern
 

thx for the solution :)

"Gary''s Student" wrote:

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.

changing text in multiple cells by pattern
 

thx for the solution :)

"Maxwell" wrote:

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.