Restrict the special characters in Excel 2010 cells

Posted by Sekar.C under Others on 9/2/2013 | Points: 10 | Views : 3532 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,
Restrict the special characters in Excel 2010 cells.

Regards
Sekar.c

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

0	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

Latest Posts