|Sorry, I don't understand what it is your trying to accomplish.|
You want cell A1 to contain the letter A and an Amount?
Then in cell B1 when a user enters a letter, transfer the letter to cell C1.
By "transfer" do you mean copy, so that the letter is in both B1 & C1?
Also, you say: excel recognizes the letter
How is Excel going to recognize the letter? Do you have a list of some sort?
Then in cell C1 enter an Amount. If you do that, then you will overwrite
the letter you just entered in the above.
Try posting a small sample of your spreadsheet
make sure to include Column Letters and Row Numbers
also read this HOW-TO which explains the use of the < PRE > tags
to align your data.
Give a before and after sample.
message edited by mmcconaghy