Did not see daddylonglegs already has the solution at the bottom of his post.
"Steved" wrote:
Hello daddylongles from Steved
I thankyou for your formula as I can have B0027 which Leave 27 and B0127
will leave
127.
Cheers.
"daddylonglegs" wrote:
It's hard to tell your intent from one example
what happens if you have B00001?
Perhaps
=REPLACE(A1,1,1,"")+0
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=566804