I am not sure if correct group, but here goes. I am not sure if this can be
done easily, but how do I set a cell based on another? Example A1 has text in
it, If A1 contains the word 'Digital' I want B1 to have 'DD' entered. Can
this be done? I am using Excel 2003, but will be upgrading to 2007 soon.