The membership's address field is a multi-line text field. This allows clients flexibility when managing membership addresses. However, this makes importing multiple lines of text more difficult than adding a single line of text.
Here is how
We recommend manipulating your existing membership list in Excel. Use the CONCAT function and CHAR(10). CHAR(10) returns the linefeed character. Its how Excel knows to add new line.
Here are a few samples
=CONCAT("11 Sample Street",CHAR(10),"City ","ST ","12345")
=CONCAT("11 Sample Street"," ",CHAR(10),"City"," ","ST"," ","12345")