Thread: formatting a cell to display a word when i enter a reference lette
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
megan62685 megan62685 is offline
external usenet poster
  
Posts: 1
Default formatting a cell to display a word when i enter a reference lette
I have a very long list of names. I want to create a column that will allow
me to seperate the names into categories: restaurant, store, brand. I want to
format the column to let me enter a letter: r, s , or b, and then the cell
will display: restaurant, store or brand
Reply With QuoteReply With Quote