Add characters

Modified on Sat, 14 Nov at 10:12 AM

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

How to add characters to text in Excel

  1. On the Power-user tab of Excel, open Add characters and select the cells to change.
  2. Choose what to add: a specific text, or a variable range such as another column.
  3. Choose where to add it: before or after a position or a delimiter (see the options below).
  4. 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.

OptionExampleBeforeAfter
After a number of charactersAdd "-" after the 3rd characterFR75001FR7-5001
After a number of wordsAdd " FY" after the 2nd wordAnnual report 2025Annual report FY 2025
After the first occurrence of a characterAdd "eu." after the first "@"jane@acme.comjane@eu.acme.com
After every occurrence of a characterAdd " " after every ";"red;green;bluered; green; blue
Content of another rangeAdd column B ("#12") after the 1st word of column AInvoice 2025Invoice #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.

See also: Remove characters to delete characters from text, and other Power-user tools to clean data in Excel, such as Delete empty cells and the advanced functions (Word_n, Concatenate_Range, CountWords).

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article