Remove Numbers from Alphanumeric String
This returns #N/A
"Bob Umlas" wrote:
if it's always the 4th position, then =mid(A1,4,255). If you want it to be
numeric, then =1*mid(a1,4,255).
If the position is unknown but is always letters followed by numbers,
ctrl+shift+enter this:
=1*MID(A1,MATCH(FALSE,ISERROR(1*MID(A1,ROW($1:$20) ,1)),0),255)
Bob Umlas
Excel MVP
"Dave" wrote in message
...
Hi,
I have a value in Cell A of ABC123.
I want Cell B1 to contain the 123 from this cell.
Can anyone tell me the formula to enter in B1. I'm sure I've seen it
somewhere before but can't put my finger on it.
Thanks!
Dave
|