View Single Post
  #1   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 ?

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


JN1BAUJ31Z0001807 JN1BAUJ31Z0
GM6BK1061012056 GM6BK1061

thanks in advance