View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Farhad Farhad is offline
external usenet poster
 
Posts: 281
Default How can i tie a word to a number

I am not sure I underestand what do you mean but lets say you are looking for
the below:

A B C
1 aaa 15
2 bbb 32
3 ccc 45
4 ddd 26

if you want to tie the word "aaa" to the number 15 in cell C1 just put the
formula below in the cell C1:
=A1&B1
if this answers you please hit yes.

Thanks

--
Farhad Hodjat


"eqcitizen" wrote:

How can i possibly tie a word to a number so that any time that word is
entered the number tied to it becomes the cell value.