Excel Study · Module 5: Text functions
Class 38Join text: & and CONCATENATE
Intermediate1:55 videoFree
First names in one column, last names in another — how do you get the full name in one cell? The ampersand (&) joins text: =A2&B2. But Excel joins exactly what you give it, so you get PriyaNair. Add a space in quotes: =A2&" "&B2.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A2 has a first name and B2 a last name. Using the & operator, write a formula for C7 that joins them into the full name, with a space between.
The answer that works
✓ checked in Excel=A2&" "&B2
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.