How can I remove 5 digit from a string ?

[Tufail]

hello
how can i remove or killed 5 digits from right side of a string ?


JN1BAUJ31Z0001807 >>> JN1BAUJ31Z0
GM6BK1061012056 >>> GM6BK1061

thanks in advance

 

[Mike H]

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]

thank you very much MIKE !

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