Hi,

If you know you are only going to have one of these four single digit
letters in A1 all the formulas supplied will work. Note that if that is not
the case then none of these formulas may return the answer you want, whatever
that might be. For example,

=(A1="p")+(A1="m")*2+(A1="d")*3

returns 0 if A1 contains "Z" or "ma" for example.

And if you entered fpmd in cell B1 you could use the shortened version of a
previous suggestion:

=FIND(A1,B1)-1

--
Cheers,
Shane Devenshire


"The IC Teacher" wrote:

I have one of four chars displayed in any cell "f", "p", "m", "d", i wish to
convert "f" to 0 "p" to 1 "m" to 2 and "d" to 3 then compare to a second set
of cells.
The second set of cells value can also be "f", "p", "m", "d" which i need to
convert to the same set of numbers.
i will then use autoformat in a third cell to determine if the second set of
cells is higher in value than the first or lower in value


The Teacher