IF THEN or Conditional Formatting question

I am using excel 2010 starter. I have a column that has alpha numeric characters.

1500-[D]-CK-Brz_PLN..................E0809
1500-[D]-CK-Brz_PLN..................E0810
1500-[D]-CK-Brz_PLN..................E0811
1500-[D]-CK-Bur_PLN..................E0812

need to create a formula or something so that I can do the ff

assuming that the column above is Column A....and rows/cells above are
1a,2a,3a,4a, etc...

I want that
1. if cell 1a contains 1500 within the first assume 30 characters with in cell 1b...display 1500
2. if cell 1a contains "D" within [] which is part of the cell display Duvet in 1c
if cell 1a contains Brz within the first assume 30 characters display Bronze in 1d


basically finding a way /formula that does

if [cell contains xyx but does not contain y] within the first X character, print [phrase/value] in cell #...value.

Thanks.