Missed year number

=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"01234 56789")),99)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Bob Phillips" wrote in message
...
=LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123 456789"))-1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"news.epix.net" wrote in message
...
Could someone please tell me how to determine the data type of each char
of a string?

I have worksheets named 'October07'. I need to extract just the month
name first and then
the year number.

I would like to loop thru the string until I find an integer character.

Thanks,
M. Miller