Hi

There isn't enough info for exact answer. Start the source string always
with letter, or can it be simply numeric too. Can there be 2 or 3 or ...
characters at start. Etc.

For case the leftmost character will always be a letter, and rest of string
characters are numbers, the next formulas will do (with string in cell A2)

=RIGHT(A2,LEN(A2)-1)
or
MID(A2,2,99)

(you can replace the number 99 in second formula with any big enough - it
must be at least as much as the length of longest string)

Arvi Laanemets


"ezu" wrote in message
...
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.

Can you enlighten me?