Excel Query

[justincase_2008]

I was given a query at work to re work into a new format. I was able to move the columns to the right order but some we still have to edit and fill in our selfs. For example Column B will always be the letter R yet i cant figure out how to set excel up to auto fill all the needed rows in that column with the letter R.

The next thing im stuck on is Column D displays the pulled product ID from our server.
Some IDs have "-BER" on the end of them showing it is a bad product. Im trying to see if there is a way to say "scan" column D for the phrase "BER" and auto cut and paste that info into column L but in the same row.


Im running Excel 2003 on a windows 2000 pc Any help you guys can give would be amazing.