View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Frank Frank is offline
external usenet poster
 
Posts: 170
Default Adding text to equal text

Is ther a way to add two cells with text to equal another cell that contains
text?

basic example:

cell:yellow + cell:green = cell:blue

I have multiple choices for information that I would like to be able to add
together (ex. yellow and green)to equal an already established answer,(ex.
blue). Can I assign numeric values to these text cells so a formula will work?