If one of your four letters in in A1 then:

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

will convert it to a value.
--
Gary''s Student - gsnu200765


"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