I have 2000 cells that contain 2 sets of information that I would like removed from the cell. I need help with creating a formula that will remove the information that I do not need so that I can copy it down and remove them from all my cells. Here is an example of one of the cells.
<tbody>
</tbody>
I need the first part of the cell removed "ITEMIMAGEURL1=" and the middle part "ITEMIMAGEURL2=" All other information would remain the same.
Can someone please help me with a formula that would remove both and leave the rest intact?
ITEMIMAGEURL1=http://d3d71ba2asa5oz.cloudfront.net/50000221/images/8004608203650__1.jpg,ITEMIMAGEURL2=http://d3d71ba2asa5oz.cloudfront.net/50000221/images/8004608203650__2.jpg |
<tbody>
</tbody>
I need the first part of the cell removed "ITEMIMAGEURL1=" and the middle part "ITEMIMAGEURL2=" All other information would remain the same.
Can someone please help me with a formula that would remove both and leave the rest intact?