Thread: Text Formating
View Single Post
  #5   Report Post  
Dave O
 
Posts: n/a
Default Text Formating
Sorry for the delayed response- try this:
=IF(ISNUMBER(FIND(" ",D7,1)),MID(D7,1,FIND(" ",D7,1)-1),D7)

Reply With QuoteReply With Quote