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!

Actualización:

Typically, the entry would look like this:

PCA: John 79826

or

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 *#

and

not like *#

1 respuesta

Relevancia
  • 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.