Don't know of any in-built features satisfying your needs, but do these
workarounds help at all?

1. If you format your cells as dates, when the email addresses are
entered they aren't converted to hyperlinks

2. Another column could be used to convert your email address to lower
case. e.g. =lower(C1) converts the contents of cell C1 to lower case.

If this is unsatisfactory you could write a macro which does the
conversion to lower case and removes the hyperlinks.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=525975