Thread: crop away the letters
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fan924 Fan924 is offline
external usenet poster
  
Posts: 238
Default crop away the letters
For the following, I need to crop away the letters with a macro, excel
97
VWXY1234567Z
CropIt = Right(Liscence, 8)
1234567Z

How do I crop away the "Z" leaving only
1234567
Reply With QuoteReply With Quote