Thread: Truncate
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Steven Steven is offline
external usenet poster
  
Posts: 32
Default Truncate
Thanks Fran
I had tried that and I am getting "Invalid Procedure Call" on

c.Value = Left(c.Value, InStr(1, c.Value, "/") - 1

Thanks again
Reply With QuoteReply With Quote