Perhaps

=--SUBSTITUTE(A1,"B","")
or
=TEXT(--SUBSTITUTE(A1,"B",""),"#")
if you need it to remain text.


"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