Text·Lesson 44 of 62ProSheets only
How to use JOIN in Google Sheets
Join a whole column
How JOIN works
JOIN combines a whole range into one cell with a separator between items. Sheets only.
JOIN(separator, range)
Example on this data
=JOIN(" | ",D2:D4)→Call back 555-0142 | Sent invoice | Call back 555-0199
The first three notes in one cell.
What you’ll do
You’ll list every SKU in a single cell, separated by commas. Joining a whole column is handy for summaries and quick copy-paste lists.
Try it
Type =JOIN(" | ",D2:D4) 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, list every SKU in one cell, separated by a comma and a space.
One payment, no subscription.