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.