How to combine first and last names into one cell
✓ Verified in LibreOffice 25.8.7.3Merge separate first-name and last-name columns into a full name.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =A2&" "&B2 | Or =CONCAT(A2," ",B2). For "Last, First" use =B2&", "&A2. |
| Google Sheets | =A2&" "&B2 | Identical. |
| LibreOffice Calc | =A2&" "&B2 | Identical. |
How it works
The & operator joins text, and the " " in the middle inserts the space — giving "Ada Lovelace". It works identically in all three apps and is easier to type than CONCATENATE. To join a whole column of name parts at once, TEXTJOIN(" ",TRUE,A2:C2) also skips any empty middle-name cells automatically.
Verified, not just documented
We ran =A2&" "&B2 in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned Ada Lovelace — exactly the expected result. Every formula here is confirmed by actually executing it.