Rick B
Lv 7
Rick B preguntado en Computers & InternetSoftware · hace 2 años

How can I data validate an Excel cell to require at least one letter and one number?

I have a field in Excel where we enter a name and a phone extension to print out on an assignment sheet. The users often enter the name, but do not assign them a phone to carry for their shift. As a reminder, I want to validate the field and issue an error if it does not contain at least one letter and one number.

Any help on how to do this? Thanks!


Typically, the entry would look like this:

PCA: John 79826


PCA: Sue S. 79844

it should be somewhat freeform, but needs to contain at least one number.

Actualización 2:

I have tried masks such as "? #" or "a#" or "aaaaaaaaa#" but nothing seems to work.

Actualización 3:

Also tried

Like *#


not like *#

1 respuesta

  • Anónimo
    hace 2 años

    Stop being a little P U S S Y and going anonymous lol you don’t scare me

¿Aún tienes preguntas? Pregunta ahora para obtener respuestas.