在收件人栏内, 变了:- [email protected], ? 为何多了一个 问号

在EXCEL 输入了一堆电邮地址
, 定时COPY & PASTE 入新邮件内寄出,

不知为何, 如在EXCEL 只打了: [email protected],

COPY & PASTE 入新邮件, 在收件人栏内, 变了:- [email protected], ?



为何多了一个问号“?” 在电邮地址尾?


可以做什么, 才不需要常常去DELETE , 令 “?” 不自动出现 ?



自动出现了那个问号, 因为实是INVALID EMAIL ADDRESS, 实会打回头.


但不是个个电邮地址都是这样.!

谢谢!

Custom Format for email addressses (Excel 2003)

A format only determines how the cell is displayed, not what the user can enter. You *can* use validation:
Say that the cell is B1.
Select B1.
Select Data | Validation...
Select Custom from the Allow dropdown.
Enter the following formula in the Formula box:
<code>
=NOT(ISERROR(SEARCH(".",B1,SEARCH("@",B1)+1)))
</code>
Make sure that Ignore blanks is checked.
Switch to the Error Alert tab.
Make sure that the Stop style is selected.
Enter an appropriate error message.
Click OK.

Note: the formula does not check for exactly 3 characters after the dot. In my country, for example, web and e-mail addresses end in .NL.

[ 本帖最后由 doraemonserv 於 2013-11-14 02:16 PM 编辑 ]