| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
From B0101 to 101
Hello from Steved
How do I please write a formula that will delete the first digits as for example delete the B0 from B0101 to leave 101 Thankyou. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
From B0101 to 101
If you always want to delete the first two digits, try...
=RIGHT(A2,LEN(A2)-2) or =MID(A2,3,1024) Hope this helps! In article , Steved wrote: Hello from Steved How do I please write a formula that will delete the first digits as for example delete the B0 from B0101 to leave 101 Thankyou. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
From B0101 to 101
Will it always be just the first 2 digits you're removing? If so, then try
this: =MID(A1,3,LEN(A1)-2) HTH, Elkar "Steved" wrote: Hello from Steved How do I please write a formula that will delete the first digits as for example delete the B0 from B0101 to leave 101 Thankyou. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
From B0101 to 101
Thanks Domenic.
"Domenic" wrote: If you always want to delete the first two digits, try... =RIGHT(A2,LEN(A2)-2) or =MID(A2,3,1024) Hope this helps! In article , Steved wrote: Hello from Steved How do I please write a formula that will delete the first digits as for example delete the B0 from B0101 to leave 101 Thankyou. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
From B0101 to 101
Thankyou Elkar
"Elkar" wrote: Will it always be just the first 2 digits you're removing? If so, then try this: =MID(A1,3,LEN(A1)-2) HTH, Elkar "Steved" wrote: Hello from Steved How do I please write a formula that will delete the first digits as for example delete the B0 from B0101 to leave 101 Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
