I'm not sure two example numbers define "these kinds of numbers" very well.
Is your general rule something like letters and digits *only* with a dash
between them, or is there other variations (different symbols than a dash
between them, a restricted set of other symbols in place of the letters,
etc.)? Is there any minimum number of digits that must appear on either side
of the dash? Where are the letters permitted to be? In the first part of the
entry in front of the dash only? In certain positions (beginning and/or end
of a number part)? Any other restrictions that you can think of?

--
Rick (MVP - Excel)


"mmcap" wrote in message
...
I cannot get the logic portion of the IF function to recognize an
alphanumeric entry. I need for it to recognize entries like T45T-6847 and
307-485. Is there a way to get the logic to return €œTRUE€� for these kinds
of
numbers?