View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Craig[_8_] Craig[_8_] is offline
external usenet poster
 
Posts: 18
Default Trim the last two characters?

Hi folks,
I'm new to VBA, but I've programmed in VB (a little bit)
before. I have several cells that I simply need to trim
off the last 2 characters from. Is there a function in
Excel that can do that?...or does someone know of a
function that will do that? I frequently have something
like: 373.62CR and I need to keep the numeric portion, but
lose the text portion. Suggestions???

Thanks,
Craig