Hi All

i have a spreadsheet with a some text that i need to remove from a single column

the text starts with this string

<a href="http://www.p

and ends with

in a new window)

but the values within change on each row

so.....

can some one please help with a formula / macro to do this?


thanks in advance for any help
as ever
newtothis...