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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HOW CAN i DEVELOP A FORMULA THAT RESTRICY SYMBOLS CHARACTERS TO B (https://www.excelbanter.com/excel-worksheet-functions/262699-how-can-i-develop-formula-restricy-symbols-characters-b.html)

Rodrjua

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

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

Steve Dunn

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

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" wrote in message
...
I am trying to developt a formula that restrict symbol characters to be
entred as data, help me!

All times are GMT +1. The time now is 03:34 AM.