| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |
|
|
Hybrid Mode
