"ezu" wrote...
In EXCEL XP PRO I am trying to write a formula to convert cells containing
a letter to a number and am having little success. i.e. A1005 to 11005
or B1273 to 21273.
If only the initial character would be nonnumeric, and only A-I, they you
could try
=--((CODE(UPPER(LEFT(x,1))-64)&MID(x,2,1024))
|