How to combine text from two or more columns in Google Sheets

By Jake Marsh · Updated

To combine text from several columns in Google Sheets, select the columns, choose Extensions > Cellwell > Merge values, pick Columns into one and a Separator such as a space or a comma, click Preview and then Apply. Each row's values are joined into a new column after the selection, exactly as they show in the sheet, so dates and prices keep their formats. Sheets' own Format > Merge cells keeps only the top-left value and throws the rest away.

Steps

  1. Select the columns to join, for example Street, City and ZIP.
  2. Choose Extensions > Cellwell > Merge values.
  3. Pick Columns into one to join each row, or Rows into one cell to join a whole column into a single cell.
  4. Pick a Separator: Space, Comma and space, Comma, Semicolon, Line break, Nothing, or Other... for your own, such as " | ".
  5. Choose where the result goes: A new column after the selection, or The first selected column.
  6. Leave Skip empty cells on so a missing value doesn't leave a double comma.
  7. Tick Clear the other merged cells afterwards only if you want the source cells emptied.
  8. Click Preview, check a few rows, then Apply.

Examples

You selectSeparatorResult
First name, Last nameSpaceAna Ruiz
Street, City, ZIPComma and space12 Elm St, Dayton, 45402
Product, PriceOther... " at "Desk lamp at $34.00
Date, EventOther... ": "Mar 4, 2026: Launch
A column of tagsRows into one cell, Commared,blue,green

The price stays "$34.00" and the date "Mar 4, 2026" because Cellwell joins what the cells show, not the raw number underneath.

Why not merge cells or a formula

Format > Merge cells is for layout: it joins the cells into one box and keeps only the first value. A formula with & or TEXTJOIN can join values, but a date turns into a serial number like 46085 unless you wrap it in TEXT with a format, and the result stays a formula tied to the source columns, so deleting them breaks it. Cellwell writes plain text you can sort, copy or keep after deleting the originals.

To split text the other way, see how to split first and last names.

What it costs

The trial is 30 days or 50 Apply runs, whichever comes first. Then $15 a month, $50 a year, or $100 once. Install from the Cellwell page.

Cellwell: Split Names, Merge, Change Case & Clean Text

Split names, split and merge text, change case, clean, extract and fill random data in Google Sheets, with a preview of every change and Undo $15 a month or $50 a year per Google account.


Questions

How do I merge cells in Google Sheets without losing data?

Use Merge values with Columns into one or Rows into one cell. All the values are joined into one cell, instead of only the first being kept.

Can I put each value on its own line in the merged cell?

Yes. Choose Line break as the separator.

Can I undo a merge?

Yes. Open History and Undo and undo the run. The new column is removed if nothing else was typed in it, and any cleared cells get their values back.

Does it skip blank cells?

Yes, with Skip empty cells ticked, which is the default.


More Cellwell guides


More Google guides