Add characters is a feature of the Power-user add-in for Excel that inserts text into existing cells at a precise place: after a number of characters or words, or before or after a given character. It replaces long combinations of Excel text functions such as LEFT, MID, FIND and CONCAT.
In short
- What to add: a fixed text, or the content of another range (for example column B inside the text of column A)
- Where: before or after a number of characters, a number of words, the first occurrence or every occurrence of a character
- Result: as values, or as formulas that update with the source data
In this article
How to add characters to text in Excel
- On the Power-user tab of Excel, open Add characters and select the cells to change.
- Choose what to add: a specific text, or a variable range such as another column.
- Choose where to add it: before or after a position or a delimiter (see the options below).
- Choose whether to write the result as values or as formulas, then validate.
Where the characters can be added
The examples below show the result of each option on a sample cell.
| Option | Example | Before | After |
|---|---|---|---|
| After a number of characters | Add "-" after the 3rd character | FR75001 | FR7-5001 |
| After a number of words | Add " FY" after the 2nd word | Annual report 2025 | Annual report FY 2025 |
| After the first occurrence of a character | Add "eu." after the first "@" | jane@acme.com | jane@eu.acme.com |
| After every occurrence of a character | Add " " after every ";" | red;green;blue | red; green; blue |
| Content of another range | Add column B ("#12") after the 1st word of column A | Invoice 2025 | Invoice #12 2025 |
Each option also works before the position or the character.
Values or formulas
Write the result as values to get plain text, or as formulas if the source data may change: the result then updates with it.
Frequently asked questions about adding characters in Excel
How do I insert a character at a specific position in Excel?
With the Power-user add-in, use Add characters: choose the text to add and the position, for example after the 3rd character, and it is inserted in every selected cell. No need to combine LEFT, MID and CONCAT.
How do I add text after a specific word in Excel?
In Power-user Add characters, choose to add the text after a number of words, for example after the 2nd word. It is applied to every selected cell.
How do I add a character after every occurrence of another character in Excel?
In Power-user Add characters, choose before or after every occurrence of a character, for example a space after every semicolon.
Can I insert the content of another column into my text?
Yes. In Power-user Add characters, choose to add a variable range: the content of column B, for example, is inserted at the chosen position in the text of column A.
Can the result update when the source data changes?
Yes, if you choose to write the result as formulas in Power-user Add characters. Choose values to get plain text instead.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article