How can I remove 5 digit from a string ?

T

Tufail

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


JN1BAUJ31Z0001807 >>> JN1BAUJ31Z0
GM6BK1061012056 >>> GM6BK1061

thanks in advance
 
M

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
 
T

Tufail

thank you very much MIKE !

Mike H said:
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
Click to expand...
 
Top