IF THEN or Conditional Formatting question help request

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.

@ ac14461

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.