Text·Lesson 39 of 62Pro
How to join text with & in Google Sheets
Join text together
How & (join) works
The & operator joins pieces of text. Put any fixed text in quotes.
=A1 & " " & B1
Example on this data
=C3&" / "&D3→GAD-1180-RED / Sent invoice
Joins the SKU and the note in row 3.
What you’ll do
You’ll build one tidy line out of a name and an email. Joining text lets you create labels, sentences or contact lines from separate columns.
Try it
Type =C3&" / "&D3 into G2 and press Enter. Watch what the sheet does.
The result will appear in G2.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Full name | SKU | Note | ||||
| 2 | maria lopez | maria.lopez@acme.com | WID-2041-BLU | Call back 555-0142 | |||
| 3 | james chen | jchen@northwind.io | GAD-1180-RED | Sent invoice | |||
| 4 | Priya Shah | priya@shahdesign.co | WID-3307-GRN | Call back 555-0199 | |||
| 5 | tom o'neil | tom.oneil@acme.com | BOX-0042-BLU | Left voicemail | |||
| 6 | Lena Park | lena.park@globex.com | GAD-2215-BLK | Call back 555-0107 | |||
| 7 | sam reed | sreed@northwind.io | WID-0918-RED | Meeting Tue |
Ctrl+/ shows the shortcuts
Drill locked
Unlock the other 44 lessons for $49.99
You’ve seen how & (join) works. Pro lets you write it yourself on real data and get checked instantly, with practice sets and section reviews for every lesson.
Your drill
In G2, build "Name <email>" from A2 (cleaned and capitalised) and B2.
One payment, no subscription.