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.
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")
=CONCAT(A1,CHAR(10),A2," ",A3," ",A4) - Where A1, A2, A3, & A4 are the cells that contain Address Line 1, City, State, & Zip code.
Here is how the formula looks in an excel cell.
Here is how the cell looks when saved as a a CSV file.
Here is how the address looks after importing.
Download Sample file using CONCAT at the bottom of this article.
Alternatively, use ChatGPT to help
Use ChatGPT to provide your exact formula you need in your exact situation. Below are some example prompts you can type into ChatGPT and get your unique formula.
How do I combine multiple address fields into a single field that contains two lines? The first line is the address (A2), the second line is the city (A3), the state (A4), then the zip (A5)?
=A2 & CHAR(10) & A3 & ", " & A4 & " " & A5
What is the excel formula to remove the commas in an excel cell (A5) and make the the address two lines. Each address has the same city "PARKTON".
=SUBSTITUTE(SUBSTITUTE(A5, ",", ""), " PARKTON", CHAR(10) & "PARKTON")