Thread: eliminate partial text in many fields
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BuffaloBilly BuffaloBilly is offline
external usenet poster
  
Posts: 1
Default eliminate partial text in many fields
I have many fields with, for example, "08:22 CST" and I'd like to eliminate
the "CST" so that I can use an IF formula with these times. How can I
eliminate the letters while keeping the numbers in place?
Reply With QuoteReply With Quote