Deleting similar content in a column

  • Thread starter Thread starter JamesBL
  • Start date Start date
J

JamesBL

I've got an Excel spreadsheet with a column containing the URL of image
of various products for sale at my site, but in front of the URL is
description of the image which I don't want. Here are some examples:

<img border=0 width=630 height=46
src=http://store1.yimg.com/I/entirelypets_1816_11609>

<img border=0 width=675 height=50
src=http://store1.yimg.com/I/entirelypets_1816_172166>

I'm trying to keep only the URL part. The data in the column i
similar, except the #s for border, width, and height change from cel
to cell. Any help would be greatly appreciated
 
JamesBL said:
I've got an Excel spreadsheet with a column containing the URL of image
of various products for sale at my site, but in front of the URL is
description of the image which I don't want. Here are some examples:

<img border=0 width=630 height=46
src=http://store1.yimg.com/I/entirelypets_1816_11609>

<img border=0 width=675 height=50
src=http://store1.yimg.com/I/entirelypets_1816_172166>

I'm trying to keep only the URL part. The data in the column i
similar, except the #s for border, width, and height change from cel
to cell. Any help would be greatly appreciated.

It looks as though the part you want to keep always starts with "http:
If your string is in A1, the following would work in B1:

=RIGHT(A1,LEN(A1)-FIND("http:",A1)+1)

You could then use edit copy and edit paste special to convert th
result into the string you want
 
Select column and do Edit / Replace / Replace http with [http. then do Data /
Text To Columns / Delimited, tick Other and put in a [

Hit next and choose not to import the first column. Then Edit / Replace /
Replace > with nothing
 
Back
Top