Thread: is there a way to delete all characters to the right of a ":"?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
  
Posts: 427
Default is there a way to delete all characters to the right of a ":"?
Hi, Lisa-
This formula will do it:
=MID(A1,1,FIND(":",A1,1)-1)

Dave O

Reply With QuoteReply With Quote