I have a column of cells (B) with addresses in this format:
3636 Bravata Dr
Huntington Beach, CA 92649
Everytime the street is followed by a "Enter" before the city.
In column C I need to pull out just the street address (the top line). Any idea the formula for this?