Deleting content in a column

  • Thread starter Thread starter JamesBL
  • Start date Start date
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
 
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

Back
Top