ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Trim (https://www.excelbanter.com/excel-worksheet-functions/102356-trim.html)

Steved

Trim

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

Trim

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.

VBA Noob

Trim

=RIGHT(A1,3)

VBA Noob

--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566804

daddylonglegs

Trim

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

Steved

Trim

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

Trim

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

Trim

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

Trim

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

All times are GMT +1. The time now is 03:35 PM.