PC Review


Reply
Thread Tools Rate Thread

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

 
 
Rodrjua
Guest
Posts: n/a
 
      29th Apr 2010
I am trying to developt a formula that restrict symbol characters to be
entred as data, help me!
 
Reply With Quote
 
 
 
 
Steve Dunn
Guest
Posts: n/a
 
      29th Apr 2010
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!


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:55 PM.