View Single Post
  #1   Report Post  
Erik Millerd
 
Posts: n/a
Default How do I limit what text is displayed?

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.