Extracting the First Line of an Address in Excel
Assuming your address is in cell A1, follow these steps:
[list=1][*]Use the FIND function to find the position of the first line break character. The formula would be:
This will return the position of the first line break character in cell A1.
[*]Use the LEFT function to extract the first line of the address. The formula would be:
Code:
=LEFT(A1,FIND(CHAR(10),A1)-1)
This will return the first line of the address, up to but not including the line break character.
Note that the CHAR(10) function is used to represent the line break character in the formula.