Google Sheets Concatenate with Space: A Practical Guide
Learn how to join text in Google Sheets with spaces using &, CONCAT, CONCATENATE, and TEXTJOIN. Practical examples, trimming tips, and handling empty cells for clean results.
Google Sheets offers several straightforward ways to concatenate with a space. Use the ampersand operator with a literal space (A2 & " " & B2), or employ text functions like CONCAT, CONCATENATE, or TEXTJOIN with a space as the delimiter. The simplest pattern is =A2 & " " & B2, which can be enhanced with TRIM to remove stray spaces.
Concatenation basics in Google Sheets
In data preparation, you often need to join two or more text fields with a single space. This section dives into why the space matters and how to implement it robustly across many cells. We'll start with the simplest approach using the ampersand operator, then show how to apply TRIM to guard against stray spaces and how TEXTJOIN can handle entire rows or columns with an optional ignore_empty flag. The space between parts improves readability and reduces ambiguity in reports. According to How To Sheets, clean, space-aware concatenation is a common requirement in practical Google Sheets workflows.
=A2 & " " & B2=TRIM(A2 & " " & B2)=TEXTJOIN(" ", TRUE, A2, B2)- Ampersand approach is fast for two cells.
- TRIM helps remove accidental leading/trailing spaces after joining.
- TEXTJOIN scales to ranges and handles blanks gracefully.
linebreaks_allowance_for_markdown_and_code_blocks_allowed_by_formatging_compatibility_validate_shapes_in_UI
Steps
Estimated time: 15-25 minutes
- 1
Prepare your data
Ensure your data columns contain the text you want to combine (e.g., first name in A, last name in B). Decide whether you want to include middle names or suffixes.
Tip: Use a header row to keep formulas readable later. - 2
Choose your concatenation method
For two cells, the ampersand approach is simplest (A2 & " " & B2). For multi-cell ranges, TEXTJOIN is often cleaner (TEXTJOIN(" ", TRUE, A2:C2)).
Tip: TEXTJOIN can ignore empty cells with the TRUE flag. - 3
Enter the formula in the target cell
Type your chosen formula in the destination column and press Enter. If you plan to fill down, select the cell and drag the fill handle.
Tip: Use TRIM to clean any stray spaces when data may contain extra spaces. - 4
Copy the formula down the column
Drag the fill handle or double-click to auto-fill. Validate a few rows to confirm correctness.
Tip: Check edge cases like missing middle names or extra spaces. - 5
Validate and adjust for blanks
If some rows have empty fields, TEXTJOIN with TRUE will skip blanks, while A2 & " " & B2 will produce a trailing space. Consider cleaning inputs first.
Tip: Consider wrapping in IF or TEXTJOIN with TRIM for robust results.
Prerequisites
Required
- Required
- Basic knowledge of formulas in SheetsRequired
- A sample sheet with columns A, B, CRequired
- Internet connectionRequired
Keyboard Shortcuts
| Action | Shortcut |
|---|---|
| Copy formulaCopy the selected formula from the cell | Ctrl+C |
| Paste formulaPaste into target cell or range | Ctrl+V |
| Fill downApply formula to adjacent cells downward | Ctrl+D |
| Undo last actionUndo if you make a mistake while composing formulas | Ctrl+Z |
| FindSearch within the sheet for related examples | Ctrl+F |
FAQ
What is the simplest way to concatenate with a space in Google Sheets?
The simplest approach is to use the ampersand operator with a literal space: =A2 & " " & B2. This works well for two cells and is easy to read. For larger ranges, TEXTJOIN with a space delimiter is often cleaner.
Use A2 and B2 with an actual space in between, like =A2 & " " & B2. For many cells, TEXTJOIN is the better option.
How do I handle empty cells when concatenating with spaces?
If you want to ignore blank cells, TEXTJOIN(" ", TRUE, range) is ideal. It automatically skips empty cells. If you must use the ampersand pattern, you’ll need to add checks to avoid extra spaces, or wrap inputs with TRIM.
Use TEXTJOIN with TRUE to skip blanks.
What’s the difference between & and TEXTJOIN for concatenation?
The & operator is straightforward for two values, but becomes verbose for many cells. TEXTJOIN handles an array or range with a single delimiter and an option to ignore blanks, making it more scalable for larger datasets.
TEXTJOIN is more scalable than & when you’re joining many cells.
Can I insert a custom delimiter besides a space?
Yes. Replace the space in TEXTJOIN with any delimiter, like TEXTJOIN(" - ", TRUE, A2:C2) to produce joined text separated by dashes. The same concept applies to the ampersand approach, substituting the delimiter string accordingly.
You can use any delimiter like a dash or comma.
Does TEXTJOIN work with numbers or dates?
TEXTJOIN treats all inputs as text. If you need specific formatting for numbers or dates, format them in advance or apply TEXT to the values before joining (e.g., TEXT(A2, "0.00")).
TEXTJOIN works with numbers and dates when formatted.
How can I apply these techniques to an entire row quickly?
Use TEXTJOIN with a range like TEXTJOIN(" ", TRUE, A2:Z2) to join all cells in that row, skipping blanks. For more control, combine TRIM with TEXTJOIN to clean each cell first.
TEXTJOIN a whole row with a single formula.
The Essentials
- Use & with a space for quick joins
- TEXTJOIN handles ranges and blanks nicely
- TRIM helps clean spaces in joined results
- Prefer CLEAN inputs for consistent outputs
- TEXTJOIN is scalable for large datasets
- How To Sheets recommends TEXTJOIN for multi-cell joins