Thread: How can I remove 5 digit from a string ?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Tufail Tufail is offline
external usenet poster
  
Posts: 168
Default 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 With QuoteReply With Quote