Restrict the special characters in Excel 2010 cells

Posted by Sekar.C under Others on 9/2/2013 | Points: 10 | Views : 1712 | Status : [Member] | Replies : 3
Hi,
Restrict the special characters in Excel 2010 cells.

Regards
Sekar.c



Responses

Posted by: Bandi on: 9/2/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Refer this link... use Custom validator in the "Data Validation" option in the "Data" Menu
http://www.tvmcalcs.com/blog/comments/disallow_special_characters_using_data_validation/
http://www.excelforum.com/excel-general/737007-disallow-special-characters-and-have-cell-length.html

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Allemahesh on: 9/2/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
You can use the below link:

http://www.codeproject.com/Articles/442357/Excel-Add-in-Framework-for-Validating-and-Exportin

Happy Coding

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sekar.C on: 9/2/2013 [Member] Starter | Points: 25

Up
0
Down
Solution:
=SUM(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT("65:90" ))),"")))+SUM(LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(ROW(INDIRECT("48:57"))),"") ))=LEN(A1)


Regards
Sekar.c

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response