using if then functrion with alpha numeric cells

I have some project numbers in column A. They contain letters and numbers. Other codes are in column A as well and I have been able to isolate them without a problem but they were all numeric. Some projects are billable and others are not(noted in column C). I was trying something like this. =IF(AND(C1="B",A1=_______),D1)

D1 has the value that I would like to place in the current cell if the forumla is true. The underlined portion of my if then formula is where i am having the problem. First, if it is possible, is there a way to say if the cell contains letters then use it? If that is not possible is there a way to format the cell to numerical even though it contains letters, this way i can use a few > or < functions to isolate the data I need.

Thanks,

That picked it up but also picked up all of the A1 cells that are numeric only as well. So it is bringing back quite a few cells that I can't have in that column. how do i add not equal to the and section of the forumula?