ExcelBanter - How can I remove 5 digit from a string ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I remove 5 digit from a string ? (https://www.excelbanter.com/excel-discussion-misc-queries/199942-how-can-i-remove-5-digit-string.html)

Tufail

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

Mike H

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

Tufail

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

All times are GMT +1. The time now is 06:58 PM.