if there are never more than 6 or less than 4 characters
=value(IF(ISNUMBER(VALUE(LEFT(A11,1))),left(A11,1) ,"")&IF(ISNUMBER(VALUE(mid((A11,2,1)))),mid(A11,2, 1),"")&IF(ISNUMBER(VALUE(mid((A11,3,1)))),mid(A11, 3,1),"")&IF(ISNUMBER(VALUE(mid((A11,4,1)))),mid(A1 1,4,1),"")&IF(len(A11)4,if(ISNUMBER(VALUE(mid((A1 1,5,1)))),mid(A11,5,1),""),"")&IF(len(A11)5,if(IS NUMBER(VALUE(mid((A11,6,1)))),mid(A11,6,1),""),"") )

"Mulvaney" wrote:

I have a column of data with the following entries: N0, AN67, AN134P, BL202,
AN67P, etc.

How can i extract just the numbers from these cells?

Thank you.