Trim

[Steved]

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.

[VBA Noob]

=RIGHT(A1,3)

VBA Noob

[WillR]

either

=RIGHT(A1,3)

or

=MID(A1,3,3)

where A1 is B0101

--
Kind Regards,
Will Riley


"Steved" wrote:

> 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.

[daddylonglegs]

It's hard to tell your intent from one example

what happens if you have B00001?

Perhaps

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

[Steved]

Thankyou Will.

"WillR" wrote:

> either
>
> =RIGHT(A1,3)
>
> or
>
> =MID(A1,3,3)
>
> where A1 is B0101
>
> --
> Kind Regards,
> Will Riley
>
>
> "Steved" wrote:
>
> > 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.

[Steved]

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
>
>

[JMB]

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
> >
> >

[JMB]

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
> >
> >