Need Help With Cleaning Data

Hi Everyone,

This is my first post in this forum... so hello to all

I need a bit of help from someone that might be able to look at my problem and go "ah come on... that's simple". Unfortunately, after much time and head scratching, I can't see the simplicity of it all.

Basically what I'm attempting to do is remove text within cells of a column whereby the info I was exporting has merged together.

To illustrate
http://widgets.com/something.html'>http://widgets.com/something.html"
is the cell data that I have

http://widgets.com/something.html
is the cell data that I want

Is there anyway of getting rid of the trailing
'>http://widgets.com/something.html"
from each of the cells within the column of data that I have

I really hope I have been clear enough with my explanations... please ask if you don't understand.

Thanks a million in advance to anyone that can help me with this riddle I have

Barry

Hi arthurbr

Thanks for the welcome and the response.

I should've clarified a bit better in my initial post that although this would be the first cell of data:
http://widgets.com/something.html'>http://widgets.com/something.html"

The next cell in the column contains completely different info. So to further illustrate:

First cell:
http://widgets.com/something.html'>http://widgets.com/something.html"
Second cell:
http://redwidgets.com/something.html'>http://redwidgets.com/something.html"

So I would need to end up with:
http://widgets.com/something.html
http://redwidgets.com/something.html
etc
etc

Sorry for the confusion.

It makes it trickier I'm sure. But is it possible?

Guys! Ye are absolute legends.

Thanks Flex. That worked perfectly.

It's kind of cheeky for me to ask one more thing (promise it's one more )

Is there a way of removing the text that comes after the .com easily?
http://widgets.com/something.html
So that the somthing.html would be removed?

Regardless... ye have made a really frustratating job so much easier. Thanks again.