| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I remove 5 digit from a string ?
hello
how can i remove or killed 5 digits from right side of a string ? JN1BAUJ31Z0001807 JN1BAUJ31Z0 GM6BK1061012056 GM6BK1061 thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I remove 5 digit from a string ?
Hi,
You can remove the 5 rightmost digiits with this =LEFT(A1,LEN(A1)-5) But your example show the 6 leftmost digits removed so prehaps you really mean =LEFT(A1,LEN(A1)-6) Mike "Tufail" wrote: hello how can i remove or killed 5 digits from right side of a string ? JN1BAUJ31Z0001807 JN1BAUJ31Z0 GM6BK1061012056 GM6BK1061 thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I remove 5 digit from a string ?
thank you very much MIKE !
"Mike H" wrote: Hi, You can remove the 5 rightmost digiits with this =LEFT(A1,LEN(A1)-5) But your example show the 6 leftmost digits removed so prehaps you really mean =LEFT(A1,LEN(A1)-6) Mike "Tufail" wrote: hello how can i remove or killed 5 digits from right side of a string ? JN1BAUJ31Z0001807 JN1BAUJ31Z0 GM6BK1061012056 GM6BK1061 thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove and replace a digit... | New Users to Excel | |||
| Excel converts 9-digit string to sci. not. when saved as csv | Excel Discussion (Misc queries) | |||
| last digit in string gets changed to 0 (16 characters long) | Excel Discussion (Misc queries) | |||
| Return a digit in a string of numbers | Excel Discussion (Misc queries) | |||
| How to find if a string starts with a digit | Excel Worksheet Functions | |||
Linear Mode
