I have a Excel spreadsheet of 2415 rows - each row being of a different named sport person.

In each of these rows, I have inserted an hyperlink into one cell (hence, having 2415 hyperlinks), so that clicking on each of these hyperlinks, will take you to a different set of on-line results, for each of the 2415 players.

However, the on-line Server has now been replaced, so that the results have now been saved to a different Server, which means that I will have to change part of the embedded URL, so that -

"http://www.evc2011.com.........." is to be replaced by "http://www.pingpong.cz/6/eurochamp/mev2011........"

Hence, my question is - Is there a function of the CC Editor, whch would allow me to do that?

Or, does anybody know of an Excel macro, or a Javascript routine, which I could run, to replace these URLs.

.

My suggestion would be to use the excel replace function and type in the find section: http://www and in the replace section http://www.new section to be added to the link.
BEFORE you do it save the file under a new name to test this out just in case so you do not ruin the original file.

hope this helps

First how was the Excel spreadsheet displayed online. Secondly it is possible to change the statement from one to another provided the logic is the same in each case. what you stated does not seem logical as the second statement would have to have additional information supplied from somewhere for each case.

Thanks for your replies -

The old link -
http://www.evc2011.com/players/index.ph … p;number=1

The new link -
http://www.pingpong.cz/6/eurochamp/mev2 … p;number=1

The only changes, as as i posted before.

I could post the Excel files, if you want a go.

Here are links to the PDF versions -

http://www.vetts.org.uk/2010-11/Tournaments/European/EVC2011_Results/European_Vets(2011)Results_Countries_A_to_F.html

http://www.vetts.org.uk/2010-11/Tournaments/European/EVC2011_Results/European_Vets(2011)Results_Countries_Ger.html

http://www.vetts.org.uk/2010-11/Tournaments/European/EVC2011_Results/European_Vets(2011)Results_Countries_G_to_Z.html

I didn't think you could use the Excel Replace function, to replace Embedded Text, if I'm wrong, how do you go about it?

Thanks for all your replies.

I could try a macro, but an easier solution was -

1) Save the Excel spreadsheet, as a Single Web Page.

2) Edit this page in (say) Notepad, by running the Find/Replace option.

3) Save this Notepad file, as an Excel File - Job done.