This follows the following rule:

If the third character is an underscore, return the fourth character as a
number.
If the third character is a number, return the third and fourth characters
as a number:

=IF(MID(A1,3,1)="_",MID(A1,4,1),MID(A1,3,2))

--
Gary''s Student - gsnu200779


"Sue" wrote:

I have a description cell that has variable alphanumeric characters. the
first one to two numbers I would like to copy to another column for the size
of the description
i.e. AA_NAAAa NNN AA N. The number I want is the first number unless the
description shows AANNANN NNNN aAa n, I would want the first two numbers.
these numbers indicate the size of the material. I don't know if a macro
and/or a function would be the best way to go.
--
Sue