What I want to do is look at cells in a column and if the entry meet the right criteria, return the cells value, if not return blank("").

The criteria I am testing for is a string of 13 characters - 4 numbers; 1 alpha character; and 8 numbers. Any numbers or text is okay.

This is what I have so far.

=IF(BG14=(AND(ISNUMBER(LEFT(BG14,4)+0),ISNUMBER(RIGHT(BG14,8)+0),LEN(BG14)=13,ISTEXT(MID(BG14,5,1)+0))),BG14,"")

Does this formula just need a little tweeking or do I need something else?

Thanks for any help...Dean