- In short
- Adds a prefix and/or a suffix to each cell and writes the result into a new column to the right. Blank cells can be skipped. A new column. Your source data stays unchanged and can be reversed in one step with Undo Last. Everything runs on your computer, with no internet involved.
What it is for
Add Prefix / Suffix is used to add a prefix and/or suffix to each cell into a new column.
When to use it
Typical use: add a fixed prefix to codes, or a unit/label suffix.
Example scenarios
- Add a fixed prefix to codes, or a unit/label suffix.
What it needs
A single column and an options dialog (prefix/suffix/skip-blanks/header); ≥1 affix required. Supported data types: text, number, date (by selection).
How to use it
- Select the range to convert.
- Run Add Prefix / Suffix from the Text & Numbers group on the XLMind Data tab.
- Tune the choices in the dialog before confirming.
- Confirm; a new column.
What it produces
A new column.
Effect on your data and undo
Add Prefix / Suffix does not change your source data; the result is added as a separate item. If it is not what you wanted, Undo Last restores the previous state.
How it differs from similar tools
No helper formulas are needed; the source area is read but never written, and the output is produced on its own.
Good to know
Size limits (≥1 affix required.).
Limitations
Size limits (≥1 affix required.).
Frequently asked questions
- Where will I see the result?
- A new column.
- What happens to invalid or unexpected values?
- Text-safe.
- How are blank cells handled?
- Optionally skipped.
- Does the result stay linked to the source?
- The result is a snapshot of the data at run time; after bigger edits, run the tool again for a current view.
- Any known limits?
- Size limits (≥1 affix required.).
Works well with
- As a preparation step, try Sentence case
- Afterwards, try Remove Duplicates in Cell
- Often used alongside this tool: Text to Numbers
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.