The Insert tab adds fixed text to every selected cell without a formula. The sidebar shows an INSERT TEXT dropdown, a text field (labelled Prefix when "Add prefix" is chosen, with the placeholder "Text added at the start") and an Apply button.
The four modes
| Mode | What it does | 1042 with SKU- / -A |
|---|---|---|
| Add prefix | Prepends text | SKU-1042 |
| Add suffix | Appends text | 1042-A |
| Add prefix and suffix | Both at once | SKU-1042-A |
| Insert at position | Inserts text at a 1-based index | see below |
Insert at position
Positions are 1-based, as the listing explains:
- Position 1 inserts before the first character.
- Length + 1 appends at the end.
| Value | Insert - at position | Result |
|---|---|---|
20261117 | 5 | 2026-1117 |
2026-1117 | 8 | 2026-11-17 |
ABC123 | 4 | ABC-123 |
To turn 20261117 into 2026-11-17, run Insert twice: first at 5, then at 8 (the string is one character longer after the first insert). Then format the column as a date if you need real dates.
Formula equivalent, and why the add-on is quicker here
With formulas, prefixing means a helper column with ="SKU-"&A2, fill down, copy, Paste special → Values only, then delete the helper. Insert at position is =LEFT(A2,4)&"-"&MID(A2,5,99). The add-on does it in place in one click, which matters most when the column is in the middle of a layout you don't want to disturb.
Everyday uses
- SKUs or ticket keys:
SKU-,JIRA-,#. - Units: suffix
kg,msfor a report (on text, not on numbers you will calculate with). - URLs: prefix
https://www.example.com/products/to a slug column. - Wrapping values: prefix and suffix with
"to quote values for SQLIN (...)lists, or with<and>for emails. - Separators in codes: insert
-into fixed-width IDs.
Step by step: build product URLs from slugs
- Put sample slugs in A2:A4:
57-google-sheets-tab-manager,58-table-converter,59-merge-tools. - Select A2:A4.
- Open Insert, choose Add prefix, type
https://www.ysskrishna.space/products/, click Apply. - The cells are now full URLs. Sheets usually turns them into links on its own.
Numbers and prefixes
Adding text to a number turns it into text. That is usually what you want for IDs, never for amounts you will sum. If you need a visible unit on a number, use a custom number format instead (Format → Number → Custom number format, e.g. 0" kg").
Practice: build image paths
Column A holds product IDs: 1001, 1002, 1003. You want https://cdn.example.com/img/1001.webp.
- Copy the column to B (keep the original).
- Select B2:B4, open Insert, choose Add prefix, type
https://cdn.example.com/img/, click Apply. - With the same cells selected, choose the suffix option and type
.webp, then Apply. - Spot-check one URL by opening it in the browser (with a real CDN path).
The formula version is ="https://cdn.example.com/img/"&A2&".webp", filled down. Use the formula if the IDs will change; use the add-on if you are producing a finished column to hand over.
| Before | After prefix | After suffix |
|---|---|---|
1001 | https://cdn.example.com/img/1001 | https://cdn.example.com/img/1001.webp |
Leading zeros
IDs such as 00042 are often stored as the number 42 and only displayed with zeros by number formatting. A prefix added to that cell may produce SKU-42, not SKU-00042. If the zeros matter, format the column as plain text (Format → Number → Plain text) and re-enter or re-import the IDs before adding prefixes.
Quick check
-
Which position appends text to the end of "ABC"?4 (length + 1).
-
You inserted "-" at 5 in "20261117". Where do you insert the second "-"?At 8, because the value is now one character longer.
-
Why not suffix " kg" on a weight column you will sum?It turns the numbers into text. Use a custom number format instead.






