If the text you wanted to strip down was in A1, then you could use a formula
like
=LEFT(A1,FIND(CHAR(10),A1)-1)
You may be able to adjust the formula to suit your need.

BTW Char(10) is the equivalent of a shift+enter in Excel.

Rgds,
ScottO

"Erik Millerd" wrote in message
...
| 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.