View Single Post
  #1   Report Post  
Dave Cadey
 
Posts: n/a
Default How do I get a letter in one cell ito equal a number in anotherl..

I wish to be able to key a letter of the alphabet in a cell ant get a number
to appear in another
eg Cell A1 could be A or B or or C with a=2, b=4 or c=7 etc
The answer should appear in say Cell B1 as 2, 4 or 7 according tp whay
letter has been keyed