Help is here.

Some addresses are in 1 cell. How do I split them into 2 or more cells in my mailing list?

How do I split them into 2 or more cells in my mailing list?

  • Highlight the cells containing the information you need to split apart.
  • Click Data > Text to Columns. The Convert Text to Columns Wizard appears.
    • Select Delimited and click Next.
    • Select Space as the Delimiter.
    • De-select Tab, if necessary.
    • Click Finish.
  • Content from the highlighted cells is broken into 2 columns: the original column and the column to the right.
    • If there is content in the column to the right, you are warned that that content will be overwritten. Click Cancel. Insert an empty column and repeat the process. You must cut and paste the split content into the correct column.

How do I combine text from two or more cells into one cell?

You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.

Combine two cells into one with the Ampersand symbol (&)

  1. Select the cell where you want to put the combined data.
  2. Type = and select the first cell you want to combine.
  3. Type & and use quotation marks with a space enclosed.
  4. Select the next cell you want to combine and press Enter. An example formula might be =A2&" "&B2.

Combine data using the CONCAT function

  1. Select the cell where you want to put the combined data.
  2. Type =CONCAT(.
  3. Select the cell you want to combine first.
  4. Use commas to separate the cells you are combining, and use quotation marks to add spaces, commas, or other text.
  5. Close the formula with a parenthesis and press Enter. An example formula might be =CONCAT(A2, " Family").