Do you want to extract the 1,2,or 3 from SE1,SE2,or SE3 ? then use
=--RIGHT(C2,1)
If there could be more than one digit (as in SE1234) then use
=--MID(C2,3,LEN(C2)-2)
The double negation in each formula is to convert text to number
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"kpruitt" wrote in message
...
I need to know how to make a spreadsheet work for what I need:

If in C2 I type SE3 or SE2 or SE1 and so forth, then I need E2 to = a
number
that correlates to each of the SE3, SE2 or SE1.

Can anyone help?????????