Thread: eliminate partial text in many fields
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default eliminate partial text in many fields
=--LEFT(A1,5)
format cell as hh:mm

"BuffaloBilly" wrote:

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