Excel Insert Before After

Add Text Before, After or at Any Position in Excel Cells in One Click

Need to slap a country code in front of a column of phone numbers, append .pdf to a list of filenames, format Social Security Numbers with dashes, or split a CamelCase column with spaces? The usual Excel answer is a chain of CONCATENATE formulas in a helper column, then copy-paste-values to remove the formulas, then delete the helper — and that’s only if your task is simple. Conditional inserts (like “before every capital letter”) aren’t possible with formulas at all. Dose for Excel’s Insert Before/After handles every common prefix, suffix, multi-position, conditional-insert, and serial-numbering job across thousands of cells in a single click.

Why Excel Needs a Real “Insert Text” Tool

Excel has no “Insert Text” command. To prefix or suffix cells, most people write a formula in an adjacent column — usually something like =”+1 “&A2 or =A2&”.pdf”. That works for the simplest case, but creates four problems the moment you actually try to ship the result:

Dose for Excel’s Insert Before/After tool replaces the entire workflow. Pick the cells, choose where to insert (before, after, at position N, before every capital letter, or as a serial-number prefix), type the text, click Apply. The change is in-place, in seconds, with no helper columns and no formulas to clean up afterwards.

Key Features at a Glance

• Five insert modes in one tool: before the first character (prefix), after the last character (suffix), at one or more exact character positions, conditionally before each uppercase / lowercase / letter / digit, and as an auto-incrementing serial-number prefix.
• Multi-position insert in a single pass: type 3,5 as the position and Dose inserts the same text at character 3 AND character 5 — perfect for formatting SSNs (123-45-6789) or phone numbers ((212) 555-1234) without writing nested SUBSTITUTE formulas.
• Conditional insert by character class: add a space before every capital letter to split CamelCase, a dash before every digit, or a period before every lowercase letter — Excel has no formula for this.
• Smart skip-or-include for non-text cells — tick Skip non-text cells to leave numbers and dates untouched, or untick it to apply the change to every visible cell.
• Include empty cells option — turn it on when you want a serial number on every row, even the blank ones; turn it off (default) when you want Dose to skip blank cells.
• Backup Sheet safety net — tick one checkbox and Dose duplicates the current sheet before applying changes, so your original data lives one tab-click away.
• Bulk-range & filter-aware — runs on a single cell, a range, a whole column, multiple sheets, or the entire worksheet. Respects filtered/hidden rows automatically.
• Live progress percentage on large operations, with ESC to cancel at any moment.
• Remember My Settings — Dose stores your last-used options so the next run opens exactly where you left off. Reset to defaults is one click away.
• Available in multiple languages. Compatible with Excel 2010, 2013, 2016, 2019, 2021, 2024 and Microsoft 365 (32-bit and 64-bit).

How to Use Insert Before/After (Step by Step)

1. Select the cell, range, column, or rows you want to modify. (Select nothing first if you want Dose to use the entire used range.)
2. Open the Dose tab on the Excel ribbon and click Insert Before/After.
3. In the pane that opens, choose your mode: Text (with one of four position options) or Serial Numbers.
4. Type the text to insert (or, for serial numbers, the starting number and separator).
5. (Recommended) Tick Backup sheet so Dose duplicates the current sheet before applying changes.
6. Click Apply. The progress indicator shows live percentage; press ESC any time you want to stop.

Add Text Before the First Character (Prefix)

Pick Before first character, type the prefix in the Text box, and click Apply. Every selected cell gets the prefix prepended in place. Example: prepend +1 to a column of US phone numbers, or EMP- to a column of employee IDs.

In the example below we selected the cells, picked the Before first character option, typed Microsoft in the Text box (with a trailing space so the prefix doesn’t run into the product name), then clicked Apply. The result on the right shows every cell with Microsoft added at the beginning.

Add Text After the Last Character (Suffix)

Pick After last character, type the suffix, and click Apply. Every selected cell gets the text appended to the end. Example: append .pdf to a column of file names, USD to a column of amounts, or @example.com to a column of usernames.

In the example below we selected the cells, picked the After last character option, typed Excel in the Text box (with a leading space so the suffix doesn’t run into the cell value), then clicked Apply. The result on the right shows every cell with Excel added at the end.

Insert Text at a Specific Position (Single or Multiple)

Pick Specify position and type one or more character positions separated by commas. Dose inserts the same text at each position — and automatically tracks the cumulative offset, so you don’t have to do the maths yourself.

In the example below we selected the cells, picked the Specify position option, entered 10 as the position and typed Office in the Text box (with a trailing space), then clicked Apply. The result on the right shows every cell with Office inserted at character position 10.

Insert Text Before Each Uppercase, Lowercase, Letter, or Digit

Pick Only add to and choose what to target: uppercase letters, lowercase letters, all letters, or all digits. Dose walks through every character in every selected cell, finds matches, and inserts your text before each one. This is the mode that Excel formulas simply can’t handle.

• Before each uppercase letter — insert a space to split CamelCase: HelloWorld → Hello World. Or insert a line break to break long PascalCase product names onto multiple lines.
• Before each lowercase letter — useful for tagging or annotating only the lowercase portion of mixed strings.
• Before each letter (any case) — separate letters from numbers in product codes like SKU1042 → SKU-1042 (when combined with a dash).
• Before each digit — insert a separator before numeric runs: Order2024 → Order-2024 with –, or pull out year prefixes by inserting / before each digit.

In the example below we selected the cells, picked the Only add to option, chose Uppercase from the dropdown, typed office in the Text box, then clicked Apply. The result on the right shows every cell with office inserted before each uppercase letter — Dose finds them all in a single pass.

Add Serial Numbers to Excel Cells

Tick the Serial Numbers option, set the starting number (1, 100, anything you want), and type the separator (. , – , or any string). Dose prepends an auto-incrementing number plus your separator to every selected cell in order.

• Numbered instruction lists — turn a column of plain step descriptions into 1. Open the file, 2. Click Save, 3. Confirm.
• Ranked product lists — top-10 / top-100 articles, leaderboard exports, contest results.
• Custom invoice or order numbers — start at 2024001 and let the increment do the rest of the work.
• Glossary or FAQ numbering — keep entries identifiable across long sheets.

If you want a number on every row including the blank ones, tick Include empty cells; if you only want numbers on rows that already have content, leave it off (the default).

In the example below we selected the cells, ticked the Serial Numbers option, set the starting number to 1, typed – (hyphen + space) as the separator, then clicked Apply. The result on the right shows every cell prefixed with an auto-incrementing number followed by – — 1- , 2- , 3- , and so on.

Real-World Use Cases

• Phone-number internationalisation — prefix +1 (or any country code) to a column of US-format phone numbers in seconds.
• Currency labelling — append USD, EUR or any currency code to an amounts column when a number-format isn’t enough (e.g. for export to a system that expects text).
• File-list extensions — append .pdf, .docx, or .csv to a column of base filenames before generating a batch script.
• ID system prefixes — turn raw numeric IDs into EMP-, INV-, ORD- branded IDs across an entire column.
• Format SSNs, phone numbers, credit cards — use multi-position insert to add dashes or parentheses at exact character positions, in one shot.
• Split CamelCase / PascalCase — insert a space before every uppercase letter to turn AnnualSalesReport into Annual Sales Report for human-readable reports.
• Email-list construction — append a domain (@company.com) to a column of usernames to instantly build mailing-list addresses.
• Numbered training material — turn unlabelled step descriptions into Step 1. , Step 2. … using the serial-numbers mode with a custom separator.

Backup Sheet & Bulk-Safe Settings

Inserting text is, by nature, an in-place modification — you don’t want every change cluttered with helper columns or duplicate sheets you have to delete later. That’s why Dose puts the safety net right inside the pane:

Skip non-text cells: tick this when your selection contains a mix of text, numbers, and dates and you only want the change to apply to text cells. Numbers and dates pass through untouched, so a prefix like EMP- won’t corrupt a numeric ID column.

Filter-aware: Insert Before/After respects filtered/hidden rows — if you have a filter applied, only the visible cells are touched. This makes it safe to run on a slice of a larger table without affecting rows you’ve deliberately hidden.

Remember My Settings: open the slide-out menu inside the pane and pick Remember My Settings — Dose stores your current mode, position, text, and toggles, so the next time you open Insert Before/After the pane opens exactly where you left off. Reset to defaults is right beside it if you want a clean slate.

Demo: Insert Before/After in Action

Frequently Asked Questions