Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code for Trim function | Excel Discussion (Misc queries) | |||
vlookup with trim function | Excel Discussion (Misc queries) | |||
Trim Cells | Excel Discussion (Misc queries) | |||
Trim and Keep the Trimmed Data | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions |