View Single Post
  #1   Report Post  
Erik Millerd
 
Posts: n/a
Default How do I remove all text in a cell after a specific character?

I have a cell linked to an Access database field. This field contains carrage
returns. I want to display only the data before the 1st carrage return. Is
there a way to do this? Perhaps useing the LEN, LEFT and other functions?
BTW this is in Excle and Access 2000.