Need Macro to FIND TEXT & Insert quotation marks

[Chrisbou]

Hi, I'm new to this forum but have used your posts many times. Thanks to all!
I can't the solution that will resolve the following though, can you help?

My spread sheet has both alpha & numeric cells, going from A1 to G1040, including a few empty ones in between.

What I need is : in every cell that starts with either http, or https, then I want to insert a single quotation mark at the beginning of the text and at the end of the text. For example, I need for this : http://www.aircanada.com/en/travelin...age/index.html to become this : 'http://www.aircanada.com/en/travelinfo/airport/baggage/index.html'

I need the formula to loop to the end of the document.

Thanks

Chris

[walruseggman]

Please Login or Register  to view this content.

On mine, it only displays the last single quote, but if you click a cell you can see both quotes in the formula bar.

[Chrisbou]

Wow! that was fast and efficient. It works perfectly.
Thanks!
Chris

[walruseggman]

You're welcome. Please mark this thread SOLVED, and any reputation points (the * in the lower left of the posts) is appreciated.