Neat !
Have to remember that one.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Harlan Grove" wrote in message
...
"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))
|