Hi,
Assuming that the data is in cell A1, array enter (Ctrl+Shift+Enter) the
following formula in cell B1.
=1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$5), 1)),0),COUNT(1*MID(A1,ROW($1:$15),1)))
You should get only the numeric portion irrespective of the number of text
characters inthe beginning.
Regards,
Ashish Mathur
"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.
Can you enlighten me?
|