Deleting content in a column
 

I've got a spreadsheet with a column that lists the URLs to the images
of all the products on my website. However, instead of just the URL of
the images, it has information on the image, like "<img border=0
width=675 height=505
src=http://store1.yimg.com/I/entirelypets_1816_172166" in the cells.
How would I go about removing the "<img border=0 width=675 height=505
src=" part, leaving only the URL for all the cells in that column? Any
help would be greatly appreciated. Thanks.


--
JamesBL
------------------------------------------------------------------------
JamesBL's Profile: http://www.excelforum.com/member.php...o&userid=15965
View this thread: http://www.excelforum.com/showthread...hreadid=274410

If they are all the same (I would guess the image size info for the pics is)
you can use Edit/Replace

Put

<img border=0 width=675 height=505
src=

as the text to find

Leave the Replace field blank




"JamesBL" wrote in message
...

I've got a spreadsheet with a column that lists the URLs to the images
of all the products on my website. However, instead of just the URL of
the images, it has information on the image, like "<img border=0
width=675 height=505
src=http://store1.yimg.com/I/entirelypets_1816_172166" in the cells.
How would I go about removing the "<img border=0 width=675 height=505
src=" part, leaving only the URL for all the cells in that column? Any
help would be greatly appreciated. Thanks.


--
JamesBL
------------------------------------------------------------------------
JamesBL's Profile:
http://www.excelforum.com/member.php...o&userid=15965
View this thread: http://www.excelforum.com/showthread...hreadid=274410