Removing part of a string (trimming a text)

[mmtoure]

Hello:
Lets say I have the following:

I am trying to get only the second http address and cut out the google part (i.e I want only things after the "&url=" to remain). I would appreciate some help with a VBA program that would look in cells in a given column and perform this.

Thanks

[Norie]

Something like this.

Please Login or Register  to view this content.

[ragulduy]

Another option:

Please Login or Register  to view this content.

[mmtoure]

Thank you very much for your help guys. Unfortunately, I can't get Norie's code to work and I am not sure why. Would mind checking it again? Thanks.

[Norie]

How isn't it working?

It would need to go in a sub, have you done that?

[ragulduy]

Norie, I don't know if Rng.value <> "" is correct - this will stop looping when the value is not equal to ""? I think you need Range.value = ""

[Norie]

You are right, mixed up my Do While and Do Until.

The code would still have run though, forever......

[ragulduy]

I think as soon as it encounters a cell with text in it will exit the loop and then the macro. It would only run for ever (or at least to the bottom row) if all your cells in column A were blank.

For what it's worth this works for me:

Please Login or Register  to view this content.

If I put the address I want in A2

[mmtoure]

So, what's happening is that after putting it in a sub and clicked run, nothing happens.

[Norie]

Forever, never... it's a typo.

[mmtoure]

Thank you both, I think it is working now! That was just a typo, i understand. Just as a follow up, is it possible to have the new link replace the content of the original cell? Now, it is dumping the link into Column B, but would be nice to have it do the change in A.

[Norie]

Remove Offset(,1).

Please Login or Register  to view this content.

[mmtoure]

Thanks for your help!