View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ConfusedStar ConfusedStar is offline
external usenet poster
 
Posts: 2
Default HOW DO I USE CUSTOM TEXT

I am creating a spreadsheet for my companys NFL picks every week. Every
person picks differently and its a master speadsheet.
Instead of retyping out every single team name I thought there was an easier
way to get the names by having abbreviattions for them and then EXCEL putting
the actual names there.
For example:
A1 is the persons name
A2-A17 are the teams but instead of typing out "BUFFALO BILLS" I want to
type "BB" and excel automatically insert the full name.

Is there a way to do this?