But Ken,
You'll notice you weren't the only one!<g
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ken Wright" wrote in message
...
Please ignore the post from the guy that didn't read the damn question
properly (ie me) :-(
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--
"Ken Wright" wrote in message
...
Slightly shorter version
=--MID(A1,MATCH(1,--ISNUMBER(--MID(A1,ROW(INDIRECT("1:15")),1)),0),LEN(A1))
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--
"Ashish Mathur" wrote in message
...
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?
|