HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B

's Computer Specifications

I am trying to developt a formula that restrict symbol characters to be
entred as data, help me!

's Computer Specifications

This will limit data entry to alphanumeric characters:

=SUMPRODUCT((MID(A1,ROW(INDIRECT("$1:$"&LEN(A1))),1)>="A")*(MID(A1,ROW(INDIRECT("$1:$"&LEN(A1))),1)<="Z")+ISNUMBER(-MID(A1,ROW(INDIRECT("$1:$"&LEN(A1))),1)))=LEN(A1)

Are there any other characters which you may wish to enter?

Steve D.

"Rodrjua" <(E-Mail Removed)> wrote in message
news:61E5CBBC-B00E-4BCF-B46D-(E-Mail Removed)...
>I am trying to developt a formula that restrict symbol characters to be
> entred as data, help me!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
symbols and characters in excel	=?Utf-8?B?dmlubm1hcnRp?=	Microsoft Excel New Users	3	23rd Jan 2006 10:18 PM
odd characters and symbols in one column	=?Utf-8?B?U3V6YW4gUA==?=	Microsoft Access Queries	2	8th Nov 2005 05:09 PM
mathematic symbols/characters	=?Utf-8?B?bWVsb2R5MzgzMQ==?=	Microsoft Word Document Management	1	12th Sep 2005 06:20 AM
Symbols and Characters	=?Utf-8?B?ZmVkdXA=?=	Microsoft Frontpage	3	26th Oct 2004 07:10 AM
Symbols and characters instead of English	SEan	Windows XP General	1	25th Jun 2004 09:34 PM