Email address

[Noctos]

Hi, i'm trying to get a type of email syntax validation so the use
would have add @ in the cell to pass the validation and is it possibl
to automatically remove the hyperlink of the address inserted into thi
cell as soon as it has been entered.

and happy new year 3 minutes to go!!!!!!

 

[J.E. McGimpsey]

For Validation:

Data/Validation/Custom =FIND("@",A1)

For removal of automatic hyperlinks:

http://www.mcgimpsey.com/macoffice/excel/nohyperlinks.html

it's written from a MacXL perspective, but you can use the same
techniques in WinXL.