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

R

Rodrjua

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

Steve Dunn

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete all data after a symbol in a field 0
Change symbols in a Network Diagram legend. 0
Remove all formatting charactersf except for paragraph and cr/lf 0
How to create bulleted to-do list using two styles? 5
Matching literal text "???" in Word 2010 field code IF statement 2
How to get Microsoft Word to find the bullet symbol: Font: Symbol Character code 183? 1
Array Formula + Indirect Reference 0
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0

Top