If I understand the question, if A1 contains the text "A", then perhaps:
=70-CODE(A1)

Since the character code for "A" is 65 (B is 66, etc)
HTH
--
Dana DeLouis
Win XP & Office 2003


"oberon.black"
wrote in message
news:oberon.black.1yaxzo_1131661503.4974@excelforu m-nospam.com...

I am creating a spreadsheet that will contain cells with the following:

A, B, C, D, E
I need these letters to equal

5, 4, 3, 2, 1
So that when I create charts I can plot using the letters (gradescale).


so I could get data like a 3000 fence made of grade "A" materials will
last say 5 years.

and that no matter what I plot the letters A,B,C,D,E will always equal
5,4,3,2,1.

How can this be done? Please help.

Thanks


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile:
http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=484118