Hi All,

I'm new to VBA and havent got a clue where to start on this. I need help on a macro that i can run that will find all instances of a string and replace it with only the middle part of the string e.g.

htps:/abc.kr/p[img]htps:/abc123.jpg[/img] fbcde5678 mr smith[/url]

to be replace with just [img]htps:/abc123.jpg[/img]

htps:/abc.kr/p[img]htps:/dce456.jpg[/img] kabcd1234 mr smith[/url]

replace with [img]htps:/dce456.jpg[/img]
...etc...

i.e. all strings will start with "htps:/abc.kr/p" and end with "mr smith[/url]"

I want to replace all these and only want to keep the section between the [img] and [/img] including those tags.

Any help appreciated. Thanks.