Deleting content in a column

J

JamesBL

I've got a spreadsheet with a column that lists the URLs to the image
of all the products on my website. However, instead of just the URL o
the images, it has information on the image, like "<img border=
width=675 height=50
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=50
src=" part, leaving only the URL for all the cells in that column? An
help would be greatly appreciated. Thanks
 
P

Paul Corrado

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top