The & sign joins text together, like glue.
keyboard Typing formulas is easiest on a computer with a keyboard.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | First | Last | Full name | |
| 2 | Tariq | Li | ||
| 3 | Nadia | Patel | ||
| 4 | Daniel | Fischer | ||
| 5 | Quinn | Evans | ||
| 6 | Jamal | Novak | ||
| 7 | ||||
| 8 | ||||
| 9 | ||||
| 10 | ||||
| 11 | ||||
| 12 |
The & sign joins text together: =A2&B2 puts what's in A2 and B2 side by side.
Type your own text in double quotes: " " is a space. So a full name is:
=A2&" "&B2
Anything in quotes is used exactly as typed. Without quotes, Excel thinks it's the name of a cell or function.
The basic Excel formulas every beginner needs, in the order to learn them: +, SUM, AVERAGE, COUNT, ROUND, percentages, IF and $. Each with an example and free practice.
Know someone fighting with a spreadsheet? Send them this page.