As a result of exporting my Contacts from Outlook 2002 I have a column
in Excel 2000 that looks like this:
https://dl.dropboxusercontent.com/u/...-FormatURL.jpg

I WANT the entries to be dynamic email links like these:




The edit box contains the string with the usual text prefix '. If I
delete that then the cell becomes correctly formatted. So I thought I
could simply select the whole column of several hundred entries and
use the Replace command to replace ' with nothing. But it fails to get
any hits. Why? More important, what's the best way to make the changes
please?

--
Terry, East Grinstead, UK