Excel 2007 : Text1 or text2 or blank in a cell

Hi,

you can use data validation for this. Click the cell, then select Data Validation on the Data ribbon.
Select "List" in the Allow drop down and type your allowed text in the Source box, separated by a comma.

You can tick the "In cell dropdown" if you want the user to select from a drop-down list instead of typing, but typing is also possible.

hth