Excel & Google Sheets lesson

Joining text with &

Musa Bello, Kano.

About 5–10 minutes · no sign-up needed

Example

& joins text together. Anything you add yourself, like a comma and a space, goes in quotes:

=A5&", "&B5

Typed into cell E5 of this sheet:

Name	City	Phone
Ada Obi	Lagos	0803-555-1234
Tunde Bakare	Abuja	0706-555-9876
Grace Eze	Abuja	0812-555-4433
Musa Bello	Kano	0901-555-2211

&Joins text: =A5&B5 gives Musa BelloKano, with nothing in between.

", "Text you type yourself goes in quotes: here, a comma and a space.

A5&", "&B5Put together: Musa Bello, Kano.

Put together: =A5&", "&B5. CONCATENATE(A5,", ",B5) does the same in Excel and Google Sheets.

Try each one in your head first, then open the answer.

1. In E4, join Grace's name and city with a space between them.

=A4&" "&B4

2. In E2, join Ada's name and city so it reads: Ada Obi, Lagos

=A2&", "&B2

3. In E5, join Musa's name and city so it reads: Musa Bello, Kano

=A5&", "&B5

4. In E3, join Tunde's name and phone so it reads: Tunde Bakare: 0706-555-9876

=A3&": "&C3

5. In D4, write Grace's city, then a dash, then her name, so it reads: Abuja - Grace Eze

=B4&" - "&A4

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

About 5–10 minutes · no sign-up needed