How to add a prefix or suffix to a cell
✓ Verified in LibreOffice 25.8.7.3Bolt fixed text onto values — ID- codes, units, currency labels, domain suffixes.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | ="ID-"&A2&"-US" | & joins text. To add without a formula, use a custom format like "ID-"@ (keeps the value editable). |
| Google Sheets | ="ID-"&A2&"-US" | Identical. |
| LibreOffice Calc | ="ID-"&A2&"-US" | Identical. |
How it works
Wrap the literal text in quotes and join it with & on either side of the cell: "ID-" before and "-US" after turns 4092 into ID-4092-US. The result is text, so it won't sum or sort numerically — if you only need the look and want to keep the number usable, apply a custom cell format ("ID-"0"-US") instead, which prepends/appends on display while leaving the real value intact. For many cells, TEXTJOIN or a fill-down copies the same pattern down the column.
Verified, not just documented
We ran ="ID-"&A2&"-US" in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned ID-4092-US — exactly the expected result. Every formula here is confirmed by actually executing it.