Trim

Steved · Jul 31, 2006

Hello from Steved

I would like to trim B0101 to 101 please.

I know how to do it but right now I just cannot remember how.

Thankyou.

WillR · Jul 31, 2006

either

=RIGHT(A1,3)

or

=MID(A1,3,3)

where A1 is B0101

VBA Noob · Jul 31, 2006

=RIGHT(A1,3)

VBA Noo

daddylonglegs · Jul 31, 2006

It's hard to tell your intent from one example

what happens if you have B00001?

Perhaps

=REPLACE(A1,1,1,"")+0

Steved · Jul 31, 2006

Thankyou Will.

WillR said:
either

=RIGHT(A1,3)

or

=MID(A1,3,3)

where A1 is B0101

Steved · Jul 31, 2006

Hello daddylongles from Steved

I thankyou for your formula as I can have B0027 which Leave 27 and B0127
will leave
127.

Cheers.

JMB · Aug 1, 2006

Perhaps

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

JMB · Aug 1, 2006

Did not see daddylonglegs already has the solution at the bottom of his post.